Data Transfer

[wilko]

Evening Gents.

I've created a database which is going to need a fair amount of data uploading into it (a long laborious procedure).

My initial plan to cut the work load for one person was to create 2copies of the database and split the upload in half (get two people to do it).

However, one of my tables is a parent to around 4 childs, therefore when i copy the information from this parent table in datasheet view from one db to another, it doesnt transfer it's associated data.

Is there anyway to get around this? Any advice/tips/hints would be much appreciated

(hope this has made sense, please let me know if clarification is needed)

 

[pbaldy]

Read here on split databases. Each user has a front end with forms, reports etc. Those front ends link to a common back end that has the data tables in it. That way they can both add at the same time.