My database has a front end (loaded on users PC) and a back end (loaded on server).
To be able to update the user database with changes to objects I use the ReplaceObject function and list the items to update.
When the update has finished, an email is sent to my mailbox so I can keep an eye on who has updated.
I have a table in the "development" copy of the database called UserUpdateStatus. The fields are UserName, UpdateNumber and UpdateDate.
I usually manually change the update number and date for each user, but would like this to happen automatically. Would anyone know how to do this? I think I am a little out of my depth on this one, but it would save me so much time!
Thanks in advance
NKA
The answer's always easy - if you know it! ;-)
To be able to update the user database with changes to objects I use the ReplaceObject function and list the items to update.
When the update has finished, an email is sent to my mailbox so I can keep an eye on who has updated.
I have a table in the "development" copy of the database called UserUpdateStatus. The fields are UserName, UpdateNumber and UpdateDate.
I usually manually change the update number and date for each user, but would like this to happen automatically. Would anyone know how to do this? I think I am a little out of my depth on this one, but it would save me so much time!
Thanks in advance
NKA
The answer's always easy - if you know it! ;-)
