Forms loading very slowly

[Tom]

I have a split Access 2000 database, the back end located on a network file server & front ends on individual PCs. After compacting/repairing or making design changes to front end form(s), they become very slow to load - some 2 minutes. If I copy & paste the form(s) onto a duplicate of the front end, the form(s) in the duplicate always load fairly quickly - 5 or 6 seconds - until I compact again or make further design changes. This behavior did not occur until after the DB was split.

Any ideas why this occurs, and how to avoid this?

Thanks, Tom

 

[gino]

where is you server located? same situation happen to my department. yes, we had a problem with our access database. our shared drive was located in a distant location. we have decided relocate the server within our building. short connection to server speeds it up. tell me what is your situation on your server.

 

[Tom]

Gino - Our server is located in the same building, and we typically do have a very fast network. In fact, earlier when the Forms, Tables, & other objects were all contained in a single file on this same server we did not have this problem.
Tom

 

[gino]

how often do you compress your database and how old is the database now?

 

[Tom]

The back end MDB gets compacted once every week. I was compacting the front end file whenever very many design changes were made, that is until I found that compacting the front end made things a lot slower.

 

[gino]

i never tried compacting the front end. did you know compression files slows down networking? i reccommend storing past data in an archive. also, try creating a new front end. compacting the front end probally slowed things down because i never compacted the front end. also, get rid of any extreme graphics if possible........well good luck.