G
Guest
From SQL Server 2000 I have to link to an MS Access file that has a database
password but no user-level security (as far as I'm aware). I could not get
the OLE DB provider for Jet to authenticate and instead had to create an ODBC
System DSN
for the Access database and then use OLE DB for ODBC databases as my linked
server provider.
Is is it possible to create a linked server using the OLE DB provider for
Jet in this scenario so I don't have to manage the ODBC System DSN?
Thanks, Tad
password but no user-level security (as far as I'm aware). I could not get
the OLE DB provider for Jet to authenticate and instead had to create an ODBC
System DSN
for the Access database and then use OLE DB for ODBC databases as my linked
server provider.
Is is it possible to create a linked server using the OLE DB provider for
Jet in this scenario so I don't have to manage the ODBC System DSN?
Thanks, Tad