M
MarkD
Using Access 2000
Hey all,
I have two tables, CUSTOMERS and INFO in an Access
database used by 3-5 people simultaneously. These multiple
users add/update the CUSTOMERS table through a bound form,
but don't touch the INFO table.
An admin runs a daily update query that updates only one
field in the INFO table by joining it to the CUSTOMERS
table and flagging where there's a match.
Now, usually this update query runs fine. Recently, I've
been getting locking violations. I have to kick out the
other users before running this query (whereas before, I
didn't have this problem). This doesn't make sense to me
since no one uses the INFO table and there's no locking on
just reading the CUSTOMER table, right?
-Mark
What could be causing this and how do I fix it?
Hey all,
I have two tables, CUSTOMERS and INFO in an Access
database used by 3-5 people simultaneously. These multiple
users add/update the CUSTOMERS table through a bound form,
but don't touch the INFO table.
An admin runs a daily update query that updates only one
field in the INFO table by joining it to the CUSTOMERS
table and flagging where there's a match.
Now, usually this update query runs fine. Recently, I've
been getting locking violations. I have to kick out the
other users before running this query (whereas before, I
didn't have this problem). This doesn't make sense to me
since no one uses the INFO table and there's no locking on
just reading the CUSTOMER table, right?
-Mark
What could be causing this and how do I fix it?