Unable to update in filtered query

  • Thread starter Thread starter ssmith
  • Start date Start date
S

ssmith

Help! I have about 15 people who are using a desk-top
Access 2000 application to process data. When they open
the first query for all the data, it is fine. When they
filter for their data ranges, they cannot update any of
the fields. This happens intermittently and is driving
me crazy. Often each person has two Accesses open at the
same time, so realistically there could be up to 25 or 30
log-ins. Any suggestions on what could be causing this?
I think it has something to do with the number of people
and/or licenses but I need outside confirmation. Any
help would be appreicated.
Sandra G. Smith
 
Help! I have about 15 people who are using a desk-top
Access 2000 application to process data. When they open
the first query for all the data, it is fine. When they
filter for their data ranges, they cannot update any of
the fields. This happens intermittently and is driving
me crazy. Often each person has two Accesses open at the
same time, so realistically there could be up to 25 or 30
log-ins. Any suggestions on what could be causing this?
I think it has something to do with the number of people
and/or licenses but I need outside confirmation. Any
help would be appreicated.
Sandra G. Smith
Click to expand...

Split your database - use the Database Splitter wizard.

This will give you a "backend" database containing only the tables,
shared by all users; and a "frontend". Each user should get a copy of
the frontend, which they will run on their own machine (not from the
server).

The problem appears to be because the users are competing for the same
queries, using different filters. If each has their own copy of the
database frontend, the contention will either not arise or (if two
users are trying to update the same record) will arise much less
often.
 
Back
Top