Thread: Linked Servers
View Single Post
  #1 (permalink)  
Old March 31st, 2005, 05:01 AM
anothervbaddict anothervbaddict is offline
Authorized User
Join Date: Jul 2003
Location: , , United Kingdom.
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default Linked Servers

:( Does anyone have an examples of how to link a password protected MSAccess database into SQL Server 2000 please?

I've tried using the following stored procedures:

The actual link is created fine, but selecting the Tables produces:
quote:Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication failed.

The actual parameters used for the stored procedures are:

(I've then tried @datasrc or @provstr separately)
@provstr='Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\test.mdb;Jet OLEDB:Database Password=xyz'


If anyone can shed any light on this matter or show me what I'm doing wrong, would be very grateful.

Thanks in advance.

Reply With Quote