I’ve recently received several email questions about using Access with ColdFusion MX on Windows 98 or ME. The ColdFusion MX Administrator does not list Microsoft Access as an available driver type when ColdFusion is running on Windows 98 or ME.
But, if you do need to work with Access, don’t despair. Here’s what you need to do:
1) Use the Windows ODBC Control panel applet to create an ODBC datasource. You’ll want to create a System DSN (so make sure that tab is selected), and select “Microsoft Access Driver” as the driver type. Enter a datasource name, and then press the Select button to specify the path to the Access MDB file (this is important, if you skip this step the datasource will be created, but it will not do what you want). When done, press OK.
2) Run a test (using an ODBC client like MS-Query or even Word) to verify that the new datasource is working properly.
3) In the ColdFusion Administrator, add a new datasource of type “JDBC-ODBC Bridge” (or “ODBC Socket”) and specify the name of the ODBC datasource.
That should do it!