MS Access way too slow on server.Locked
We have 10 users sharing Access 2000 database. Front end is on each workstation, all with Win98. Tables on the server – main table has 6,000 records linked to a table with 17,000. The main form has 2 tabs, 80 controls. The main form can take 5 minutes to open, except for the first person to long on. Most PC have 64 – 96 MB RAM.
Question: Could this be a server problem, do I need to convert to SQL, or some other option?