Hi

Anyone knows how to detect there has been modified the record?


I am trying to develop a multi user application with VB6.
using ado with msacess
and I like to if there is a way to tell the user that the record they trying to update it has been modified another user

thanks :)

Add an extra table in your access db (dbtables) with user and db tablenames as headers. Fill in the tablesnames field with all the names of the tables in you db. Now each time an update button is pressed on your application, it should first search the dbtables table for a match to the current table you wish to update and so display your message with the last user who updated the form. In the code, you update the dbtable table by filling in the user field against the corresponding db table field. The user field can be populated by the login form I presume you have.


It Ends Here

yeah that's fine too, you will a need a form as a report
for that thing, that only open by administrator of the program
this is might be usefull for administrator program, and filtered by date/time
or else . . .

thanks

:)