Link two Access Databases over the internet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Take a look into Replication.
Click to expand...

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.
 
if you used Access Data Projects then you might be able to do some sharing..
pretty easily

MDB doesn't support _ANY_ networks though
 
Back
Top