merging two databases

[Martin Stabrey]

I've got a simple database with only one table. I'm wanting two people to be
inputting data into the table. Can I merge these once both are done?

Mart

 

[Larry Daugherty]

There are a couple of concepts to consider

1, Split your database into a FrontEnd (holds everything except the
tables) and a BackEnd which holds just the tables. You get there by
making a copy of your application and call the first copy *GUI.mdb
(FE) and call the 2nd copy *DAT.mdb.

2. Put *DAT.mdb in a folder visible to both users on the LAN.

In *GUI.mdb, go to Tools | AddIns | Linked Table Manager and link to
the tables in *DAT.mdb - out there on the server where you just put
it.

Now give a copy of *GUI.mdb to each person who might want to enter or
see the data. Hot dang, you're doing multi-user stuff!

You can continue developing in a copy of *GUI.mdb and each time you're
satisfied with the level of changes and you've debugged them, once
again link to the real data out there on the server. Now email a
message to all of your users telling them to rename or delete their
current version of *GUI and replace it with the copy of the newer,
better version attached.

HTH

 

[Martin Stabrey]

Thanks Larry.

I should have gone on to say that the data capturers are not in the same
place (actually about 100 miles apart!) ie. LAN won't apply.

Cheers
Martin

 

[Guest]

Two people enter information into identical tables in two different but
identical databases. When ready, copy and paste/append data from the table
of database1 to the table in database2.