How can I lock a table? Please help me!!!!

[Rafael]

How can I lock a table (Recordset) to avoid generate duplicate records with the same value in one of its fields, while I adding a record in a multiuser enviorement.?
Please, help ASAP!!!!

[OneSource]

Hi Rafael,

I am not a SQL whiz, but you should be able to Execute a Select Statement before updating the Recordset to make sure that a duplicate is not included. Or if not SQL, you can use a RS.Find (or something like that) method to see if the record exists.

Hopefully someone reading this will give you the exact syntax of how to do the methods suggested above.

All the best.