Access DB Runs slower on Network than Hard drive

[carl]

Hello,

I have a newly created database that I created by running it off of my
hard drive, but now that I placed it onto a shared network drive it
runs considerbly slower, on the order of 20-30 times slower. The
majority of the delay is when the user has to input into a form through
combo boxes that then run a query to display a subform for data entry.
I did notice that when I hit ctrl+ break while I am waiting for the
subform to display it will display the subform as desired. Also the
speed in which new forms open when a command button is pressed is
slightly slower, but no where near the lag of the subform.

Any help or comments will be greatly appreciated,

Carl

 

[Guest]

Hi Carl,

The network is the slow point, so you have to expect some delay versus
accessing data on a local hard drive. However, here are some ideas for you to
consider:

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html

You will really be helping yourself to disable NameAutocorrect, set all
SubDatasheets to [None], and verify that you have a persistant connection
(when you are the only one in the database, you should always see a locking
database file [*.ldb] for the BE database--you should not see it disappear
and re-appear as you navigate around in your FE database).



Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Ron2006]

And make sure that the application is split per the suggestions. AND
that the FE is on the local drive.

If it is on the network then the data AND the form have to come over
the network. The data is bad enough, but BOTH can make it really slow.

Ron