Re-synching data between 2 databases

[dpk136]

I have a database that i made in access, there is a front end and a back end. What we need to do is grab only the data that the reps for the company will need and put it into their own back end. This will be taken with them and possibly edited while they have it out. When they come back to the office, they need to link back up to the main back end and put the updated data back in there. Is there any way that access does this or any way to programatically do this?


David Kuhn
------------------

http://www.davidpkuhn.com

 

[Remou]

It seems to me that you are talking about Replication.

Microsoft Access replication FAQ available in Download Center

http://www.tek-tips.com/viewthread.cfm?qid=1299852&page=1

 

[dpk136]

i guess it could be called that. all i need is to copy the database (only the data that is valid to their rep code) and when they get back, make updates based on what they have changed.

David Kuhn
------------------

http://www.davidpkuhn.com

 

[lespaul]

Access has that ability built in, it's called Replication.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[dpk136]

I've been looking it over, is there anything that would allow me to do this programatically?


David Kuhn
------------------

http://www.davidpkuhn.com