himanshurulez

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.

Webserver won't help, unless you're running a app and you can modify it to connect to database server instead of ms access.

Actually depending on where you're from. Software developer ain't that expensive here in malaysia.

Hi
Thanks for the reply...I tried ur solution...But I now facing another problem..actually i have used database splitter in MS Access to split the database...now access does some internal coding to link the forms in the spitted database to the tables database...now how do i link the splitted database in the remote location to the tables database in the main server..??

HiI am a manager at a trading/wholesaling company (and have no programming background). I customized the Northwind sample access database to make invoices and keep accounts for my company. We now opening another office at a distant location. So, the order entry will be done at two points(we plan to use the same Access database).I am not able to figure out how to access the same MS Access database from two different location(as LAN can't be used). Moreover, we can't afford to pay huge sums to the software developers. Can intranet or uploading the database to a web server be a solution to this?? How?? If not, plz suggest something else?PS: I just need a central location where the database can be stored, and all employees can run and modify the database via internet (or some other source)