Filter by form mystery

[Richey]

On my main form, if the user attempts to filter on the 'product details' field (a memo field) most of the time the following message appears
"The microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time"
It then seems to apply the filter but every field has '#Name?' in it. This is the only field that this happens, and never are more than 1 user using the database at the same time

Regards
Richey

 

[Guest_imported]

Not sure what it could be but I have had Access get messed up. You could try making a copy of your database with a new name, decompile it and then re-compile it and try again. Don't do this to your main copy!
click start - run - type this in - msaccess /decompile
then open your copy of the database. After it opens you will get a message about the code. Close Access. Open Access like normal. Open your copy of the database and get into a code window. Click debug then Compile and save all.
Then test your form.

That is all I can think of.