Importing several databases into one

[DougP]

We have 10 people with laptops in the field using the same Access database. They each have their own copy loaded on their laptop and it is not using a backend or anything.
When they come back in the Office I need to gather all of the data and bring it together.
Each person will be creating a unique set of records because of the location they are going to so nothing should overwrite as far as the records go if they are brought into one table in a master database. This is also an ongoing thing the go back out create another unique set then come back in I need to upload that. So I want this to be fairly easy for me or them. I can write VBA very well but was looking for hints as to any easy way. looking at 30-50 thousand records.


DougP, MCP, A+
I Built my own R2D2
I love this site and all you folks that helped me over the years!

 

[PHV]

Did you consider Replica ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MichaelRed]

Replica could work, particularly if you have (or add) a field which is guaranteed to be unique (and NONE or the intrinsic fields is). A convenient way MIGHT be to add the user name to each field along with a guid field. If you forced everyone to log onto the app, the combination would be unique (enough) for most light weight apps.




MichaelRed

 

[DougP]

I don't now to replica works never used it.

DougP, MCP, A+
I Built my own R2D2
I love this site and all you folks that helped me over the years!

 

[MichaelRed]

with all the fancy titles, seems like you should at least be willing to peek at the docs and give it a try?




MichaelRed