Very Slow to Open

[infomania]

Using Access 2002, I created a small database on my laptop by importing the design and data from a Access 2000 application that was a design master (I created). I then created a replica and placed it on the network server and retained the local copy as the Design Master. (The new db is in Access 2000 file format)

What's odd, is that it takes a very long time for me to open the database or to open and forms (locally). Other users, using the network replica, have no problems opening the file from their machines. Is it my machine or something about replication with Access 2002??

 

[Eupher]

Off the top of my head, two things I can think of to check:

1) Check that the DB is saved in a compiled state. Open any code window, then select Debug->Compile. If Compile is not grayed out, your DB is not compiled and depending on how much code is in your DB, you can see a definite performance hit. So just compile then save.

2) There is a "feature" in Access 2002 which I believe is turned on by default, called "Name AutoCorrect". When enabled, Name AutoCorrect keeps track of the names of database objects, so if you change the name of a table or form or whatever, Access will automatically update the name everywhere else it appears in your DB (except in code modules). Sounds great, except it can make forms take a looooooooooong time to load. To disable, from the main menu select Tools->Options, then select the General tab, and de-select all options under Name AutoCorrect.

HTH...

Ken S.

 

[infomania]

Ken,

Thanks for the suggestions. In the Replication Design Master I checked and the DB was not complied so I compiled and saved. The open time didn't seem to improve. The DB is only 1 MB in size (at this point) and it takes ~ 1 minute to open in design mode, now that is is set up for replication (before creating the first replica, the DB snapped open).

I could not find the Name AutoCorrect features on the General Tab (even though the MSA Help says it's there). My version of Access 2002 is 10.2616.2625.

It is interesting that other users acccessing the DB replica on a network drive, using Access 2000, have no performance problems opening the replica.