MrDeveloper
Programmer
Hi,
I have recently split out my application into a Front-End MDE app / Back-End MDB database. Forms now distributed to users PC's on the network. Each desktop shortcut now points to local copy of Access, network copy of the security (MDW) file and then local copy of the forms (MDE).
System loads ok but now runs terribly slow (upto 9 minutes to bring back a record in some instances!). The delay in record-accessing prior to splitting used to be a matter of seconds when it was an all-in-one MDB accessed entirely from the server by networked users.
I have trawled the web for hints/tips and have come up with the following 5 improvements (below) and for the benefit of other users experiencing similar problems, I will post to this thread whether any of them helped when I try them.
However, before I go in to try and solve the above problem, does anyone have any further suggestions as to things I could do? I am concerned the following may only make minor improvements to the delays.
Any further help/suggestions would be really appreciated.
Thanks in advance,
MrD
List so far:
1. Shorten the back-end database (MDB) file-name to 5 characters.
2. Move it near to the root of the server.
3. Move the back-end MDB to a faster server.
4. Turn 'Track Name AutoCorrect info' off
5. Set subdatasheet name property of tables to [none]
Anything else I could add to this list when I try fixing the system?
I have recently split out my application into a Front-End MDE app / Back-End MDB database. Forms now distributed to users PC's on the network. Each desktop shortcut now points to local copy of Access, network copy of the security (MDW) file and then local copy of the forms (MDE).
System loads ok but now runs terribly slow (upto 9 minutes to bring back a record in some instances!). The delay in record-accessing prior to splitting used to be a matter of seconds when it was an all-in-one MDB accessed entirely from the server by networked users.
I have trawled the web for hints/tips and have come up with the following 5 improvements (below) and for the benefit of other users experiencing similar problems, I will post to this thread whether any of them helped when I try them.
However, before I go in to try and solve the above problem, does anyone have any further suggestions as to things I could do? I am concerned the following may only make minor improvements to the delays.
Any further help/suggestions would be really appreciated.
Thanks in advance,
MrD
List so far:
1. Shorten the back-end database (MDB) file-name to 5 characters.
2. Move it near to the root of the server.
3. Move the back-end MDB to a faster server.
4. Turn 'Track Name AutoCorrect info' off
5. Set subdatasheet name property of tables to [none]
Anything else I could add to this list when I try fixing the system?