SQL Server - Access Database Synchrosnization

[philh]

You have a couple of options:

1. Find an ISP who will actually work with you on the SQL Server
functionality.
2. Try to create a linked server to the Access database. You can then at
least use bulk insert statements. If that doesn't pan out because your ISP
disallows link servers, see #1.
3. Bite the bullet and write the delete/insert code on a table-by-table
basis.

Good luck.

[The ScareCrow]

I would

1. Create a CF page to upload the ms access db, this page would then (after
upload) execute a sql server stored procedure
2. Stored procedure would bump the data in the tables and then use the bulk
insert sp to insert the new data.

But as Phil has said, I find it rather inconsiderate that a isp would take
your money for the sql server but then cut back access to the major
functionality of it.

Ken