Merging data from one database into another

[Lynx2x]

Hello everyone!

As you can see in title of this post, I need to merge data from one DB into another.

Let me explain a little bit more. I have a split database with front end DBcompanyFE and back end DBcompanyBE. BE is on the server so users at company (3 users) can access it with their own FEs.

I also have 2 users that are working at some other location (geographically) and they have identical BE of database (DBcompanyBE) and their own FEs.

Now, my problem is, that at each location there is different data entered, but on both locations all the data is needed. What would be the easiest and mybe most automated way to merge/combain those data.
Does anyone here have some experiance with that? Any solution would be very helpfull.

Thank you all in advance and have a wonderfull weekend

 

[diberlee]

I'm far from an expert, I'm lurking around waiting for an answer to my own question at the moment.

However, I just this morning had a similar issue to you which I have solved using an append query and a delete query.

Some reading here should get you on the right track: http://office.microsoft.com/en-gb/a...ble-by-using-an-append-query-HA010076526.aspx

Hope that helps

 

[Lynx2x]

Hi, and thanks for reply.

I know that I could do this with append query, but this wouldnt be good for employees to do. There must be some easiest way or even some programe or vba code or something that someone has.
Also append query appends all data from one table to another, but I want to append just new or different data, if you know what I mean.

Again, thanks for reply, I appreciate it.