Microsoft KB Archive/95054

{|
 * width="100%"|

ACC1x: Driver Cannot Be Found When Attaching to SQL Server

 * }

Q95054

-

The information in this article applies to:


 * 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

Issue type : kbprb

Technology :