If you still have problems, try making your path to the database file a full path, ie H:/data.mdb rather than data.mdb (say). Rather trivial but it has caught me out sometimes on my NT4 machine at work.

You could also try a different connection string: 

Driver={Microsoft Access Driver (*.mdb)}; DBQ=database.mdb

[download]


I would also recommend taking a look at the OLE based access to an Access database. Here you can have access to the ADO stuff directly within Perl. An example bit of code for inserting and retrieving the last insert ID can be found in: Retrieving the last insert ID with Access.

However, if you do try the OLE stuff then you really do need to learn how ASP does it as it works in almost exactly the same way. I know thats almost swearing here (oops :P) but the docs for recordsets and connection objects in ASP are quite complete so you should be able to find what you need.

Hope that helps.

Update: Added connection string

In reply to Re: WIN32:ODBC Perl Connection to Micros~1 Access Database by simon.proctor
in thread WIN32:ODBC Perl Connection to Micros~1 Access Database by mr_dont

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.