Increase Performance when using DB from Network

[fh2level]

At work we have to keep our DB file on the company network since there are three of us that have to use it. This causes the program to run extremley slow, and nearly impossible to use when connected to the network via VPN. Is there anyway that each of us can run our own copy stored ON our computers (containing all referance tables for combo boxes etc...) but have all the data that is being entered into the DB be stored on the Network to increase the performance?

 

[PHV]

Split the database in one Back end (BE) and Front ends (FEs).

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[RuralGuy]

And some useful performance tips from Tony Toews.

http://www.granite.ab.ca/access/performancefaq.htm

HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit