A:  The ODBC driver provided with Access 2.0 (ODBCJT16.DLL with a file size of <65k) is designed to work only within the Microsoft Office environment. To work with ODBC/Access in Delphi, you need the Microsoft ODBC Desktop Driver (ODBCJT16.DLL, internal version number 02.00.23.17, with a file size of approx 260k) kit, part# 273-054-030 available from Microsoft Direct for $10.25US (post on WINEXT for where to get it in your country if you are not in the US). It is also available on the Jan. MSDN, Level 2 (Development Platform) CD4 \ODBC\X86 as part of the ODBC 2.1 SDK. Be aware that your redistribution rights for the Desktop Drivers are pretty restricted by Microsoft. For info on (and objections to) the restrictions post on the WINEXT forum.

You also need the following ODBC files.

Minimum:
ODBC.DLL       03.10.1994, Version 2.00.1510
ODBCINST.DLL   03.10.1994, Version 2.00.1510
ODBCINST.HLP   11.08.1993
ODBCADM.EXE    11.08.1993, Version 1.02.3129

Better:
ODBC.DLL       12.07.1994, Version 2.10.2401
ODBCINST.DLL   12.07.1994, Version 2.10.2401
ODBCINST.HLP   12.07.1994
ODBCADM.EXE    12.07.1994, Version 2.10.2309

The following steps will get you started in Delphi

1. Using the ODBC Administrator, set-up a datasource for your database. Be sure to specify a path to your mdb file. For the purposes of this explanation we'll say that the datasource name is MYDSN. The correct driver name is:

   Microsoft Access Driver (*.mdb)

2. Load the BDE Configuration utility.

3. Select New Driver.

4. Give the driver a name (call it ODBC_MYDSN).