Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
swenri
Yak Posting Veteran
72 Posts |
 Posted - 2008-10-06 : 16:22:40
|
| I’ve a table called tblShipments in MasterImport2.mdb which is created everyday out of a text file which is ftp’ed. A linked table tblshipments has been created in another database for the same table on the same server for another user. Whenever the user runs the query in the other database, the MasterImport2.mdb database opens and it creates a lock file. Thereby, when the user runs the same query again it says the below mentioned error. "Couldn't use "\\ \MasterImport2.mdb", file is already in use"Is there any other round about way to prevent this error? Please advice me how to prevent this error.Thank you, |
|
|
|
|
|
Error with linked tables in MS-Access