Applying a Filter to a Table - Get error...

  • Thread starter Thread starter Jennifer Siefert
  • Start date Start date
J

Jennifer Siefert

Hello,

Since we upgraded our small database to 2002, we have had
problems with it getting corrupted...

What happens is there are 5 users that update file
receipt information. When everyone is using the forms,
we are working great, however, when one person applies a
filter to the table in the datasheet view, anyone who was
in the form view gets corrupted when they try to apply a
change to their information because it's acting like it
cannot find the records. Then, I need to kick everyone
out of the datbase and run compact/repair - then we are
good to go.

Does anyone know where I can reference information on
using a Filter when there are multiple users? I've tried
to inform the person using the filter to use the queries
option, however, it's a habit for them. Maybe I can set
something up to reference the data correctly...

Help. - Thank you.

Jennifer
 
Yes...we did this about three months ago when we started
getting the corruption error. We have been fine for
several months, until my boss did a filter on the table,
and went to a meeting while I was adding and changing
records...
 
Back
Top