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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy