I've an application running on my local system with local sql server database.
I've an other application running on internet (like on www.abc.com) and it has Microsoft Access database.

I just want to insert some records from local sql server to online MS Access databas.
Problem is this I can't connect to online access database from my local machine to insert or update records in it.

anybody has any idea of how to connect to an online database from local system using asp.net.

you can create a asp.net web service application and write your methods to access your ms access database in the webservice, then create a windows application on your local computer and add web reference to it, then you can do all sort of operations.

I can only add reference from my local machine or in the same solution but I want to add reference of web service located on the internet.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.