Data update from local to online db 1

[kbdci]

I have an MS Access database that I update on my local PC. I would like to use ASP.NET to run queries that will extract data from specific fields in the local database and use that data to update only those fields in a similar database at my website. How can I do that?

Do I have to run the ASP code from my online website or can I run it from a website that I run in an IIS on my local PC?

Thanks.

Kathy

 

[jbenson001]

Do I have to run the ASP code from my online website or can I run it from a website that I run in an IIS on my local PC?

You will have to be able to connect the the remote DB from your PC. If that's possible, then you can run the app locally.

 

[kbdci]

I have learned that my host service does not allow remote connections to the database. If I set up my ASP code to run from the server, will I be able to access my local database? How can I specify the connection for an Access db on my local PC?

Will any of this be easier if I convert my db to SQL Server? I know I still won't be able to connect remotely, but will it be easier to connect from the host server to my local db?

 

[jbenson001]

How can I specify the connection for an Access db on my local PC?

You can't

Switching to SQL Server is a good idea, but still does not help with your connection problem.