February 27, 2007 at 4:47 pm
I have SQL Server 2005 loaded on 4 machines, all with a LinkedServer to an AccessDatabase. All four can read the data from the Access Database. 2 of them are giving me problems. If the Access database is open in Access, I get the error:
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "rbcsdata" returned message "Could not use ''; file already in use.".
also, on the same 2 computers, I cannot write to the tables in the access database. I get the error:
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "rbcsdata" returned message "Operation must use an updateable query.".
2 of the computers, everything works fine but 2 of them, I get these errors.
Any help would be greatly appreciated.
February 28, 2007 at 7:45 am
Do you get the same errors when a 2nd user opens Access and tries execute these tasks?
February 28, 2007 at 7:53 am
That's no problem. Multiple people can be in these databases at the same time and there are no errors.
February 28, 2007 at 8:35 am
check the FileDSN settings on the 2 computers u have issues with..i mean the FileDSN's that were created to access SQL Server.
February 28, 2007 at 9:56 am
just a hunch, the SQL Server should have rights to write to the file server where the Access file is stored.
February 28, 2007 at 10:03 am
The sql server and access databases are on the same machine.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply