Sync Local Access Table to the Internet for ASP.Net web app using

[Guest]

Nubie Question...I'm sure this is simple, but here goes anyway. I have a
small VB.Net application that uses a local Access Database. I want that same
local data replicated to an Internet web site so that I can use an ASP.NET
page to work with the data. My DB and Application is not really big enough
to mess with SQL server...
QUESTION: What is the best way to sync my data to the web. I've tried the
built in replication in Access and encountered a few problems:
1) It makes everything huge! Yuck.
2) It wants to replicate locally, not directly to the web.
3) How do you schedule replication?

Is there some cool code I can use from within my local VB.NET app to push
the data up to the web.

 

[Ken Cox [Microsoft MVP]]

Hi Stan,

Not sure what you mean by "sync to the Web". Does the Web version get
updated and then merged back in with the offline version?

If you just need to get the data to the Web, how about writing an Access
macro to export the data as an XML dataset to the Web directory and then let
an ASP.NET application consume the dataset on the fly?