Thread: Linked Servers
View Single Post
  #5 (permalink)  
Old April 5th, 2005, 03:19 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

If anyone had this problem and was using the Search and found this thread, here is my work-around.
I don't actually link the MDB but using T-SQL try the following:

 
Quote:
quote:SELECT * FROM
Quote:
OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=c:\mytest.mdb;
Persist Security Info=False;
Jet OLEDB:Database Password=mypassword')...MyTable
I've also tried the Data Source as a network path and that also works. The only thing I can't confirm is the Jet drivers on the same box as the SQL Server installation.

Reply With Quote