I have a split application with a shared Access 2K database on an NT 4.0 Server with an Access 2K front end app which users load on local Windows 98 workstations to access the database.
There is one form with about 6 tabs and about 15 list boxes displaying data from all over the database.
Moving between records on the test system is fine (<1 second), but when I load it on the 98 systems it takes about 20+ seconds for the form to load and at least 6 seconds to move to a new record.
I am wondering if this is in any way related to the references that are loaded. I am currently using:
- Visual Basic for Applications
- Microsoft Access 9.0 Oject Library
- Microsoft DAO 3.6 Object Library
- Microsoft ActiveX Data Ojects 2.1 Library
- OLE Automation
In that order. I don't really know what most of those mean, so I don't know if they are in the ideal order or if they are all necessary.
What is recommended?