Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a SQL server 2000 and an Access database mdb connected by Linked server on the other hand I have a program in c # that updates data in a SQL table (Users) based data base access.

When running my program returns the following error message:

OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication failed.
[OLE / DB provider returned message: Can not start the application. Missing information file of the working group or is opened exclusively by another user.] OLE DB error trace [OLE / DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize:: Initialize returned 0x80040E4D: Authentication failed.] .

Both the program, the sql server and database access are on a remote server.

On the local server the problem was solved by running the following:

"sp_addlinkedsrvlogin 'ActSC', 'false', NULL, 'admin', NULL".

Try on the remote server the next, without result: "sp_addlinkedsrvlogin 'ActSC', true, null, 'user', 'pass'".

On the remote server and from the "Query Analyzer" sql update statements are working correctly.

Can you think of what may be the problem?

Thanks!

share|improve this question
add comment

1 Answer

Try accessing it without a username/password first. If that doesn't work, create a workgroup file for the MDB (it's an MDW) in access and use the username/password for it.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.