July 18, 2003 at 12:48 pm
Hello,
I would like to setup a MS Jet database as a Linked Server in SQL 2000. I tried using Add New under Linked Servers in the Enterprise manager I do it the same as if it were a SQL Server, choosing MS Jet 4.0 OLE DB Provider. I was unable to get it to work. Has anyone had any luck with this?
Best wishes,
Barry O’Connell
July 21, 2003 at 1:10 am
I've had no past trouble accessing Access, Excel and Text files using that provider. Have you tried the example in BOL under "OLE DB Provider for Jet"?
Cheers,
- Mark
July 21, 2003 at 5:34 am
Make sure
Access DB is not encrypted or secured
The server has access to the file
Change security to 'they will be mapped to' with a remote user of admin and no password.
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply