Forms loading very slowly

Tom

New member
Local time
Today, 06:01
Joined
Jan 19, 2000
Messages
6
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
 
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.
 
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
 
how often do you compress your database and how old is the database now?
 
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.
 
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.
 

Users who are viewing this thread

Back
Top Bottom