Avatar of jclemo

asked on 

SQL Server linked to Access Database table problem

I have an SQL database which is linked to an access database.  I have the link all setup which works in the server management studio when I log on using Windows Authentication but not when I log on using SQL Server Authentication.  I assume this is due to folder permissions but I can't figure out how to setup the link so that I can get this to work.  I get the following error when trying to access the table using SQL Server Authentication:

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "ACCESSDB" reported an error. Authentication failed. Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "ACCESSDB".

Then when I try to assign an impersonated ID to is I get

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "ACCESSDB" returned message "Cannot start your application. The workgroup information file is missing or opened exclusively by another user.".
Microsoft SQL Server 2008SQL

Avatar of undefined
Last Comment

8/22/2022 - Mon