Link two Access Databases over the internet

[Mariner]

Hello! I am fairly new to Access. I have my website which I did using
ASP.Net, which uses an Access Database. I have the website and it DB on my
webserver. I'd like to have a second database on my home computer. Is it
possible to lik the DB on the server to the DB at home over my internet
connection (may be using FTP) so that when i open 2nd DB it automatically
updates it's tables from the DB on the server. Is this possible? If so is
there an ADO code for the connection and getting data from Webserver DB.
Thank you in advance

 

[Douglas J. Steele]

Take a look into Replication.

Check http://support.microsoft.com/kb/282977 (or
http://support.microsoft.com/kb/182886 if you're still using Access 97), and
http://office.microsoft.com/en-us/access/CH063664271033.aspx for
information.

 

[David W. Fenton]

Take a look into Replication.

Probably won't work, as you have to synch in place, and the
connection will be WAN speed or less, which means no DIRECT
replication. That means you'd have to set up INDIRECT replication,
which requires a synchronizer running on both ends of the synch. I
know of no ISPs that support this, as the synchronizer cannot run as
a system service.

 

[Aaron Kempf]

if you used Access Data Projects then you might be able to do some sharing..
pretty easily

MDB doesn't support _ANY_ networks though