accessing remote ip address database in ms access on webserver

i have pc on which my msaccess database is present which collect data from local network , and i have another web server on which 2.0 application runs, both pc and server are far apart physically so both having internet and own different ip addresses,
 so want to access my data from pc ie ms access 2003 database file in my application on server ,can anybody guide me how it can be acchived.

thank you,
10/6/2008 4:52:23 AM 5668 articles. 1 followers. Follow

2 Replies

Similar Articles

[PageSpeed] 20
Get it on Google Play
Get it on Apple App Store

It is apparently possible to connect to a remote machine and read an Access database:, but I have never, and would never try it.  You would be better off putting the Access database on a proper server within your network, and then creating some web services that read the data from it, and return that data to your remote web application.  Or better still, use SQL Server.


Regards Mike
My site
10/6/2008 6:52:22 AM

I think you need remote data service for this to work but I think Micrsoft has deprecated this.

I think your best bet is to upgrade to MS SQL.

DiscountASP.NET: Developer Ready ASP.NET Web Hosting
- Microsoft Gold Certified Partner
- Voted 2008, 2007, 2006 & 2005 Best ASP.NET Web Hosting by asp.netPRO Magazine
10/6/2008 8:39:52 PM