Filter by form mystery

Richey · Aug 29, 2000

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 · Aug 31, 2000

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.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Filter by form mystery

Richey

Technical User

Guest_imported

New member

Similar threads

Part and Inventory Search

Sponsor