Hi,

What would be the best practice to make offline use of a database?

In my company, we have an online FM DB that we work with. We also have some UMPC that we use on the field.

I would like to allow the user to work on there DB records while they are outside and then resync the records on the main DB.

Any advice would be great.

Nick

Something like Dr. Cologon's NightWing Base36 uID System would be worth studying.

You should also consider SyncDeK | WorldSync.

Ok I found a work around for the primary key. Here's my solution.

I create a serial number in the table and an text field which is a calculated value.

The calculation goes as follow.

pkRecordID = serialNumber & Substitute(Get (HostNICAddress); ":"; "")

Quite simple. So each time the value is unique for each computer, even the one that are on the field and needs to upload the unsync records on the server.

So each key is unique.

Edited August 28, 200817 yr by Guest