MS Access Database Sharing

[JDCD201]

Hello Guys,

I have created a database & forms for data entry for the company I work for in order to streamline one of our processes.

What I am struggling to get my heard around is allowing multiple users to work on the database at the same time without the same Primary Keys being used and clashing when the databases are combined.

This has to be done offline really as they are inspecting lifts including the shafts at client sites so there is no guarantee that they will have access to the internet.

I have bought in tablets and ruggedized them and they have been tested out in the field and work. We have now got to the stage where we want multiple engineers out on sites performing these inspections. The data is mail merged across into a word document to produce reports.

Thanks for your help,

James

 

[KenHigg]

See if this helps:

Replication

 

[JDCD201]

Thanks Ken,

We are looking at trying to keep it all in house if possible but I shall have a read later.

Thanks,
James

 

[KenHigg]

Ok - I must have mis-understood the situation.

 

[spikepl]

If you in your tablet DB have a composite primary key, consisting of autonumber and a unique TabletID, then you could combine data ad libitum, since each record is uniquely identified.

 

[JDCD201]

Thanks for the help guys! I managed to make the ID's unique using the tablet number and the system time as a string. I have another query now regarding the synchronization of the data:

http://www.access-programmers.co.uk/forums/showthread.php?p=1352392#post1352392

Any help would be greatly appreciated!

James