Re: MS Access 97, Access 2007, Run-Time and MySQL

[banglore agent1]

What's the UI/Form you're using to do the entry of your data? Another or the built in form in access. My guess is the latter. In that case, there's not much option left. You need to built a VPN network so that the remote client at your new office will appear as if it's running in LAN. I would recommend Hamachi, since it has the a free version for small scale deployment. Once your VPN is up, you simply shared the access file across the network. This might not sounds like a very scalable idea, but since you can't afford software developers, that should be the only way out. Btw, this option also limit you to a few connection per session. Don't expect to connect/run more than 5 client from the remote location, unless you have very reliable and fast internet connection.

If you already have another app to access your "access database", then simply modifying the connection parameter of that app will allow you to connect remotely. You'll need to setup some form of domain name for your main office's internet connection. Try No-Ip or DynDNS.
----------------------------------------
Games Online
Website Appraisal



Edited 1 time(s). Last edit at 09/10/2009 06:23PM by banglore agent1.