Ms-access – Using MS-ACCESS split database over internet

client-serverms-accessodbc

I am working on a database that is expected to operate over multiple distributed locations in a client-server model. I am limited to MSACCESS and currently using a split database for a local network.

Can we extend this split database over the internet securely. Note we cannot employ more sophisticated solutions such as MSSQL or sharepoint.

We have a fixed IP, however found no examples of using MSACCESS on the internet and therefore not much information about security.

Came across this thread: How to share MS Access 2010 database over the Internet

but we have no virtual terminal login.

Thanks

Best Answer

You can check out my article here:

http://www.kallal.ca//Wan/Wans.html

In the above I explain your options. I mean, if you have a server anyplace (as you plan), then I see little reason to not use a free edition of SQL server for the back end.

Also, I not sure why you think some technologies like using SharePoint or office 365 (cloud) are expensive? The basic edition of SharePoint is free with any server edition of windows (2008 R2 last time I looked was under $500).

And you can get office 365 plans staring at $6 that supports not only you placing your data tables in the cloud and linking your MS Access VBA front end to those tables on o365, but for that same low price you ALSO can create web forms in Access and publish them to office 365. The following video of mine shows this new ability for access 2010:

http://www.youtube.com/watch?v=AU4mH0jPntI

So a $6 per month plan to do this is going to be less than one service call for any of your computers.

Related Topic