Transfer data from one database to another ?

[SpookiePower]

I have made an customer database for my work, that runs just fine.
Now one of my users want me to make an access program
on his laptop where he can enter new customers. When he
then return to his job he want to be able to transfer the new customers
from his laptop to the database on his work. I have never tryed to
transfer data from one database to another, but how can it be done ?
And if so, can it be done in a simple way, so he can do it by him self
?



My PhotoGallery
www.photo.activewebsite.dk

 

[Arvin Meyer [MVP]]

There are several ways. The simple way is to append the new data to the
existing tables. Do that by linking the tables from the laptop to the office
system (or just copying the file and linking it) then running an Append
query which takes only the data entered after a specific date/time.

You can also use replication:

http://download.microsoft.com/download/access2000/whitepap/1.0/win98me/en-us/replfaq2k.exe

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access