Posted by David Kirkman on 10/01/82 11:39

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.

• Next in forum: Re: Chain of triggers - how to break it?
• Prev in forum: Re: one for the SQL experts - dare I say TRICKY SQL!
• Thread view: Re: SQL Server 2K Linked Access 97 Server not working

[Reply to this message]