josephwalter
Programmer
I've created a linked server from an unsecured Access 2000 database to SQL Server 2000. Under the security tab, I've got all users being mapped to the remote login 'Admin' with no password.
When I try to view the list of tables in the linked server _from the server_ it works fine. I can query the tables, as well. When I try to view the list of tables in the linked server (or run queries against it) _from other workstations_, I get the following error:
Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an eror.
I've read many posts on other sites about this error, and I've gone over a number of Knowledge Base Articles. All with no luck. Please help.
When I try to view the list of tables in the linked server _from the server_ it works fine. I can query the tables, as well. When I try to view the list of tables in the linked server (or run queries against it) _from other workstations_, I get the following error:
Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an eror.
I've read many posts on other sites about this error, and I've gone over a number of Knowledge Base Articles. All with no luck. Please help.