ACC2000: Slower Performance on Linked Tables - 261000 indicates that if the database has many linked tables that also have many relationships, and the table that you are opening has its subdatasheet Name property set to [Auto], this can make the table slow to open.Subdatasheets are a new feature in Access 2000 Therefore, you are more likely to notice this behaviour after you convert a database from an earlier version.
If a change was made to an object only that one record in the system table was updated.Also make sure you have the fastest available reasonably priced (don't go spending lots of money on SCSI if you don't need to) hard drive controller systems and hard drives. I'm quite happy with the performance of my tower systems IDE 100 controller and hard drives. For more information see ACC2000: Saving Objects in DB Slower Than in Earlier Versions - 246306 The problem is likely related to server security as each directory you navigate must be checked against the domain security system.This may be particularly acute in combo boxes and subreports when using a FE/BE system as I've noticed these appear to be poorly optimized.Access does automatically create indexes on primary keys, foreign keys and other fields as per the Autoindex on Import/Create in the Tools The problem with too many indexes is that this will slow down record insert and field updates as the indexes have to be updated. For example when doing a bulk loading of records, such as when converting a system, it can be very beneficial to delete all the indexes, load the records and create the indexes fresh again.Note that in some performance tuning I just did for a client adding an index on a boolean field in a "master" table containing 800 records dropped the form load time from 30 seconds to 3 seconds.