El_Pablo Posted July 31, 2008 Share Posted July 31, 2008 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 Link to comment Share on other sites More sharing options...
Fitch Posted July 31, 2008 Share Posted July 31, 2008 Something like Dr. Cologon's NightWing Base36 uID System would be worth studying. You should also consider SyncDeK | WorldSync. Link to comment Share on other sites More sharing options...
El_Pablo Posted August 28, 2008 Author Share Posted August 28, 2008 (edited) 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, 2008 by Guest Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5733 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now