Posted by Erland Sommarskog on 02/11/06 00:53

David Kirkman (foxwaycomputing@gmail.com) writes:
> The providerstring column is set to NULL in master...sysservers
>
> I created the linked server exacltly as specified here:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-
> us/acdata/ac_8_qd_12_6a44.asp
> For Access 97 it appears that the providerstring field is left empty.
> The database is unsecured, so I also mapped a SQL Server user to the
> Access Admin account as described in the MSDN page.
>
> I have dropped and created the server several times now.
>
> The Microsoft.Jet.OLEDB.4.0 provider works OK from a VB6 application on
> a PC but there are no other client applications installed on the server
> itself so I am unable to verify connectivity from an alternative source.

Exactly where is the Access database located? Is it on the SQL Server
machine? If it is not, under which Windows account is SQL Server running?
To be able to access network resources, SQL Server must be running
under a domain account, not under Local System.




--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]