Last record ID

Sharing the same backend with multiple users may be tricky. If User 1 and User 2 write to the same table at the same time, it may be hard to determine the ID of User 1's record, and the ID of User 2's record, which may lead to data inconsistencies, or other bad things. And if you are thinking that such an event is too unlikely, well, think twice. It happened to me and it was NOT a pleasant surprise... This tutorial provides an easy solution which works with both DAO and ADO.

Duration: 7m 39s