Question:
How come I'm getting a General SQL Error about not being able to load
MSJTER32.DLL when trying to connect to Access?
Answer:
MSJTER32.DLL comes with Access 95. The most common cause of this error is
when DLL32 in BDEADMIN is configured to connect to Access 95 DAO and the
Access 97 DAO is installed. To configure BDEADMIN to use the Access 97 DAO,
Select the Configuration Tab, Configuration: Drivers: Native: MSACCESS and set
DLL32 to IDDA3532.DLL.
Another way to get this error is if BDEADMIN is configured to connect to the Access
95 DAO and the Access 95 DAO is not installed. Obtain the Access 95 DAO from
Microsoft.