Why does it take my MS Access linked table so long to open?
Posted on 2011-03-01
I have an access application with split front and backends.
One of the backend database files is called WI.mdb.
This database includes two tables, WIversion and WIstock.
WIversion only includes one record, however, WIstock inlcudes 650,000 records.
When I double click on the WIstock from the Access Database window it takes 20-23 seconds before the information appears on the screen.
The frontend is located on an XP Pro workstation and the WI.mdb file is located on a Windows 2000 server.
I have tried keeping open a second form (tied to the WIversion table), but regardless of whether the second form is open or not, the time that I have to wait to open the WIstock table is not changed.
This seems like a long time to wait. It also takes a very long time to open a recordset created from this database.
Is there anything I can do to speed things up?