Searching Memo Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I need to search a memo field for any user supplied value. The search contains a like '%value%'. The problem is that if I have multiple users logged in, I get a message that says 'The Microsoft Jet Engine stopped the process because you and another user a trying to make changes to the same record.....' I need to be able to write queries that can return values that have a match.

Thank you,
 
Are each of your users working on their own copy of the front-end database?

If not, you should split your database.

Rick B

message Hello,

I need to search a memo field for any user supplied value. The search
contains a like '%value%'. The problem is that if I have multiple users
logged in, I get a message that says 'The Microsoft Jet Engine stopped the
process because you and another user a trying to make changes to the same
record.....' I need to be able to write queries that can return values that
have a match.

Thank you,
 
You might be running into a problem with the name "Description". I think it is
doubtful, but since fields in Access can have a Description property and so can
tables, there might be some confusion. If you can't change the field name, you
might try making sure you bracket the field name with square braces - although
that might be problematic if you are using an adp (MSDE or SQL Server).
 
Back
Top