Accessing a split database from home

[ChrisSedgwick]

Good morning,

Simple question really! Is it possible to access a split database where the back end is held on the works server from home?

Thanks,
Chris

 

[Minty]

Yes - depending on where and how your BE data is held.
MSAccess BE - If it is defined as a network drive lets say X: as long as you are VPN'd into your work network and X: can be seen it will work.
SQL BE: The same as above really except you will need to be able to connect to the SQL server via VPN.

Be warned that complex queries can run very slowly or hang if you don't have a good connection between the two sites.

 

[ChrisSedgwick]

Minty,

Thanks very much! I've set up VPN and made sure the MSAccessBE is stored on a network drive.

Many thanks,
Chris.