Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Queries on linked tables

Status
Not open for further replies.

kirnavi

Technical User
Feb 4, 2002
29
US
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
 
Oh, I forgot to add we are running NT and Access 97.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top