[thelist] Accessing Access

Minh Lee Goon writes:
 > I have to write a script to open an MS Access file, check some
 > information, change a value from "FALSE" to "TRUE", and then forward the
 > user to a page depending on the information submitted from the HTML form
 > and the information returned.

from the perl form win32 FAQ:

---

9.3. How do I access databases from my Perl script?

There are a couple of extensions that have been developed to access databases from Perl for
Win32. Win32::ODBC is widely popular, and is available on CPAN and at this URL: 

http://www.roth.net/odbc/ 

Another module, ODBCTable, lets you tie an ODBC table to a Perl hash and use it just as you
would a hash. It's available at the following URL: 

http://www.endcontsw.com/sampledownload.htm 

The one you use is a matter of taste. Note that you must have an ODBC (Open DataBase
Connectivity) driver for the DBMS you're using in order to use either of these modules. For
more information on ODBC and how to configure database, check the ODBC applet in the
Control Panel. 

---

I've used Win32::ODBC, and can recommend it. I haven't used it in some time, but I remember it being an easy to use and well documented module.

- dwayne