Creating a remote

C

Channell

I have created an Access database but I would like help entering the data. I
have figured out how to export the database to another computer so the other
person can help with the data entry, but I can't figure out how to merge
their information with mine without deleting all of my information. I know
it's possible to create a remote but I can't seem to figure out how to do it.
 
R

Roger Carlson

If you are on a network that both users are connected to, you need to split
your database into a Front-End and a Back-End. The BE contains only the
tables. The FE contains everything else including LINKS to the tables in
the BE. After doing that, you can put a copy of the FE on the other user's
computer and you can both enter data.

If the two computers are not on the same local area network, but can link
over a wide area network, then you need to use Replication. I suggest
downloading the Replication FAQ http://support.microsoft.com/kb/282977/en-us


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Top