ACC1x: Driver Cannot Be Found When Attaching to SQL Server

• Microsoft Access versions 1.0, 1.1

SYMPTOMS

When trying to attach a SQL Server table, or open a previously attached table, you receive the following error message:

Driver specified by data source could not be loaded.

CAUSE

The most likely cause of this error message is a missing, damaged, or incorrect version of the SQLSRVR.DLL file.

Other situations may indirectly cause this error message. For more information, query on the following words here in the Microsoft Knowledge Base:

debugging and troubleshooting and tips and Q102437

RESOLUTION

To correct this problem, verify the following:

• There is a single copy of the SQLSRVR.DLL file in your Windows SYSTEM subdirectory.



• You have the correct version of the SQLSRVR.DLL file. The version installed by Microsoft Access version 1.0 is dated 10-16-92 and has a size of 135792 bytes. You need either this file or a more recent version.

Additional query words: kbtshoot tshoot

Keywords : kberrmsg kbusage OdbcOthr
Version : 1.0 1.1
Platform : WINDOWS
Issue type : kbprb