How to update local access DB

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

Hi,

I have got an MS Access 2003 db on the server. I want to
creat a copy of this db on the local machine. Is there any
way to update the access file located on the local machine
with that on the server without downloading the latest
version of the file from the server. If there is any way
to do this, let me know how to do it.

Thanks!

Matt
 
Matt,

This can be done by the Replica functionality built in Access (Tools >
Replication in A2K, not sure where in the manu structure of A2K3).

The question is, though, is this the best way to go? Replication is useful
in cases where you have users in remote locations without a permanent
connection to a main server, so you get asynchronous updating of separate
copies of the same db, and require a mans of periodically syncronizing
hem - that's exactly what replication does. On the other hand, it blows up
the db's size considerably, replicas are not constantly up-to-date, and
replication itself can be a drag. That is to say, don't do it if you don't
need it.

If, on the contrary, you have constant access to the server, why would you
want to do that? Is it a multi-user database? If yes, then the best practice
approach is to split it into a Front End / Back End (again, Access has a
built in wizard for this, Tools > Database Utilities > Database Splitter in
A2K), leave the back end (containning only the tables) on the server and
install a copy of the front end (containing everything else but the tables,
with links to the tables in the BE) on each user's PC. If multi-user is your
case I suggest you spend some time browsing through the multiuser newsgroup,
you'll definitely find some interesting stuff in there.

HTH,
Nikos
 
Back
Top