Is it possible to access MS Access 2010 database over the internet without using Sharepoint or similar services? I have a server where I want to put the back end and email the front end to various people. As I understand this is easy if all the users are on the local network. But how do I share my database over the internet? Thanks.
MS Access 2010 is a file-based database. Thus the only way to share it with a separate front-end / back-end database (linked tables) setup is if you expose the file share on the Internet. This is most definitely NOT a good idea.
Even if you use a VPN to add security you will probably find performance unacceptable. The only realistic solution is to use a SQL Server back-end and link to that from the MS Access front-end databases.
|show 1 more comment|