Best way to share a database?

[aimeepeter]

Sorry if this topic has been covered elsewhere already...

I have a database which needs to used by two people. Currently the file is saved in a shared network folder which both users can access.

The problem is that using the database from the network location is very slow when the users are away from the office an accessing the file over the VPN - it so slow that it is unusable.

I have done a lot of reading on access and VBA for access but I am still confused about the best way to share this file.

Is spliting the database into front-end and back-end the way to go about this?

Any suggestions are welcome.

Cheers.

 

[georgedwilkinson]

You should definitely split any database that more than one person will be using concurrently into FE/BE. But that won't solve the slow problem when you're out of the office (VPN is very slow). I recommend using terminal services of some type. Since you are on a VPN, you might consider trying VNC, which is free. Other good options are Citrix, Windows Terminal Services, Logmein.com, and gotomypc.com.

You would just run the database from your local desktop in the office as though you were sitting right there, via the terminal services program.

 

[Rabbie]

I have seen in other posts on this forum that it is not a good idea to use Access over a WAN. There is a high risk of corrupting your database.