I using an Access table from VB 6. I need to be able to support 6-8 users in the database at the same time. (Note - the users will be using my app, NOT Access) Problem - when running either SQL or DAO updates, I'm getting "Cannot update - locked by user Admin on machine BOX123". The conflict is actually happening - two (or more) users are in same tables, but are updating different records and this happens. I need a code workaround, options to set, etc to handle this gracefully and make sure the updates get into the database anyway. Microsoft is really short on "theory of operation" docs, which is what this would fall under.