A
abcstx
I run a program which updates data using action queries and RunSQL code in
Visual Basic in Access 2003; however, if another user uses the database to
update records, either manually on a form or by running code that inserts
records, she gets a lock error. Even though we're not updating the same
records (only the same table, perhaps), it doesn't let us both update the
data at the same time. This is frustrating to our users. Is there any way
around this?
Thanks!
Visual Basic in Access 2003; however, if another user uses the database to
update records, either manually on a form or by running code that inserts
records, she gets a lock error. Even though we're not updating the same
records (only the same table, perhaps), it doesn't let us both update the
data at the same time. This is frustrating to our users. Is there any way
around this?
Thanks!