Greetings,
Hopefully this will be an easy answer for you VB pros out there:
I am creating an app that will use a shared database to furnish many users with information. The user will be allowed to add and edit the information contained therein.
I am using DAO against Access 2000. I am also using a class to retrieve the record from the DB. I can pass the class a value (ClientID) and it 'knows' how to populate itself with the record. As soon as it's populated, the connection to the DB is closed.
Here's the problem: How do I ensure that the information written to the database by one user will not overwrite any changes made to the same data by another user?
Eagerly awaiting any suggestions,
Guru2B
Hopefully this will be an easy answer for you VB pros out there:
I am creating an app that will use a shared database to furnish many users with information. The user will be allowed to add and edit the information contained therein.
I am using DAO against Access 2000. I am also using a class to retrieve the record from the DB. I can pass the class a value (ClientID) and it 'knows' how to populate itself with the record. As soon as it's populated, the connection to the DB is closed.
Here's the problem: How do I ensure that the information written to the database by one user will not overwrite any changes made to the same data by another user?
Eagerly awaiting any suggestions,
Guru2B
