My client would like to have the Access database I've built accessible through the internet. Is there a standard or a de facto standard for technologies to do this? I've been trying to set up a VPN, but the software included with Windows Vista seems quite finicky, and I haven't been able to get it up.
I can't tell you how many times I have consulted with clients and I ask them if they need their application to go online and they say NO and I remind them that if they want an Internet based solution later, the application needs to be re-written in something like PHP/MySQL and NOT Access, so you can't change your mind later without a total loss... they still say no, they don't need it to go online.
I then develop their application in Access.
Then they say "ok, that's great!! Now let's just put this online so we can access it from anywhere and we're done".
I remind them about what was said initially and no doubt they get upset disappointed that they can't just "upload it" somewhere.
So, if you do find a good solution to running an Access database over the 'net, please let me know!
hey folks, Access is designed for local installation i.e. LAN. One can extend it via Terminal Services (Citrix) if there exists a solid private network. One doesn't enter into the world of Terminal Services lightly and so you would have it in a large corporate network and its used for a variety of applications. This is also, by the way, now becoming the area of SharePoint too.
Alternatives are few; one can do a Remote Log On. There are commercial services out there like GoToMyPC.com and others - they work pretty good. But you have to have your PC turned on at your office. And there is a noticeable latency/lag.
Another alternative is AccessTables.com; they will replicate the tables so they are shared. The good side of this is that the database runs locally in all locations - so it is fast. But the intent is that the database tables get consolidated/replicated once or twice a day - - so it isn't for real time data sharing between locations if that is needed.
Have done all of these options. If the data consolidation/sync is ok to occur once a day (typically overnight) - I default to AccessTables.com because it is simple and the local running of the database is preferred by users. But every situation is different.