access slow to open and close
Posted on 2001-06-11
I have a main database on a server( 6 users in total).I have another db on 2 pc's running NT.I have linked a table on the workstations to a table on the server.The linked table has about 45,000 entries and one primary key.
On the workstation db's i created a couple of queries for printing various reports. There is only a small bit of code that creates and destroys a temp query to use as records for a listbox. The 2 workstations that run this db are getting incredibly slow to open and close, preventing me from running other apps.The other 4 computers seem unaffected. I compacted the main db and workstations db. The workstation db was 500k after compacting.I ran it once,closed it and it was ~900k.There was no data added to the linked table. Any suggestions? Is there a more efficient way to get the data from the server without linking?