June 1, 2009 at 6:38 am
I am able to create linked server for access database. But while trying to access data from linked server, it is giving following error...
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "access" returned message "Cannot start your application. The workgroup information file is missing or opened exclusively by another user.".
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "access" reported an error. Authentication failed.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "access".
Has anybody come across this & solve the error. I understand that this is because of the system.mdw file. But in the case, where do we specify this...
June 1, 2009 at 8:38 am
What MS Access version do you use? Please check the compatibility of provider to the version of MS access.
June 2, 2009 at 12:51 am
I am using Access 2000 i.e. supplied with Office 2000.
June 2, 2009 at 5:50 am
If you use a workgroup database (e.g. system.mdw) then you must specify the system.mdw in the connection string:
please see http://www.connectionstrings.com/access
example
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:System Database=system.mdw;User ID=myUsername;Password=myPassword;
Hope, this helps!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply