Creating a mobile database for tablet or PDA

[hinser13]

Dear all

I have several customers that want to be able to use their database remotley to record client data, quotes etc.

I have produced a scaled down version of the database before, to record data on a tablet PC or PDA, but I always have the same problem!

Overwriting data!

Is there an easy way to write code to upload the table (specific fields) data, from the tablet version once back in the office. BUT! only add new data collected.

Thanks

 

[Uncle Gizmo]

Have a look at replication...

 

[hinser13]

Thanks for your reply, Replication at forst glance seems to fit perfect until the next auto number.

When the database is replicated the auto numbers give wildly inappropriate values!

I want auto numbers to create unique job numbers, before the replication we were up to job 769.

Now replicated the next unique number should be 770!
buts its like: 126789956!

Can this be easily soughted (looked at replication ID value which doesnt seem to solve the issue)

Thanks Mark

 

[Uncle Gizmo]

I want auto numbers to create unique job numbers,

Thanks Mark

You have just discovered why you should not use auto numbers for any meaningful value in your database. The auto number should only ever be something to link one row of data in a table to another row of data in another table. They should never be used to represent something meaningful like a job number.

 

[boblarson]

Thanks for your reply, Replication at forst glance seems to fit perfect until the next auto number.

When the database is replicated the auto numbers give wildly inappropriate values!

I want auto numbers to create unique job numbers, before the replication we were up to job 769.

Now replicated the next unique number should be 770!
buts its like: 126789956!

Can this be easily soughted (looked at replication ID value which doesnt seem to solve the issue)

Thanks Mark

If you use an Autonumber for something meaningful (except for generating a UNIQUE number) then you are not using them correctly. Autonumbers should not be used for job numbering, invoice numbers, etc. If you want those numbers then you need to look into the DMax + 1 method (and perhaps with a locking table to assign them) and you assign them at the last possible moment just before the record is added.