Hi - I have a database that is shared by 25 or so users, who all belong to a shared workgroup. This database contains data that is downloaded from our payment system. The tables used to be refreshed nightly but became too big so we now download the data into *.dat files and then created linked tables.
My problem is that when one user is running a query (and subsquently, viewing the query results), the table(s) that the query draws from are locked to everyone else, showing an error message like "cannot open *.dat... exclusively opened by another user" or something along those lines. This never happened when the tables were updated so I'm thinking it must have something to do with the linking.
Can anyone help?
Thanks,
Susan
My problem is that when one user is running a query (and subsquently, viewing the query results), the table(s) that the query draws from are locked to everyone else, showing an error message like "cannot open *.dat... exclusively opened by another user" or something along those lines. This never happened when the tables were updated so I'm thinking it must have something to do with the linking.
Can anyone help?
Thanks,
Susan