A
Aldo
I am running a function from the switchboard that opens
a "MAKE TABLE QUERY", then opens a form to enter data
into TABLE1.
The query finds duplicate addresses in TABLE1 then
deletes the existing TABLE2(Duplicate Records) and
creates a new TABLE2 with all duplicates found. When a
new address is entered, on LostFocus on address field a
macro runs to check TABLE2 for existing addresses. If it
finds dups, a message tells you you have entered the same
address as an existing address. Just a warning. When you
click OK on the warning, a form of TABLE2 opens showing
the exisitng address and related info. This is basically
and error trap. Everything works perfectly.....until a
second user tries to run the function while the form is
opened by the first user. Error 3009 : ....cannot lock
TABLE2 because it is currently in use. Is this because I
am opening the form with the same function that creates
the table and the function doesn't end until the form
closes? Or any other ideas?
a "MAKE TABLE QUERY", then opens a form to enter data
into TABLE1.
The query finds duplicate addresses in TABLE1 then
deletes the existing TABLE2(Duplicate Records) and
creates a new TABLE2 with all duplicates found. When a
new address is entered, on LostFocus on address field a
macro runs to check TABLE2 for existing addresses. If it
finds dups, a message tells you you have entered the same
address as an existing address. Just a warning. When you
click OK on the warning, a form of TABLE2 opens showing
the exisitng address and related info. This is basically
and error trap. Everything works perfectly.....until a
second user tries to run the function while the form is
opened by the first user. Error 3009 : ....cannot lock
TABLE2 because it is currently in use. Is this because I
am opening the form with the same function that creates
the table and the function doesn't end until the form
closes? Or any other ideas?