Re: Searching Memo Fields

From: John Spencer (MVP) (spencer4_at_comcast.net)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 17:26:19 -0400

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).

Brandon Campbell wrote:
>
> Rick,
>
> The database is split. The problem has to do with the memo field, or more to the point, the 'Description' field. I have another memo field that I can search in. Both fields exist in the same table.
>
> I don't think that this would cause a problem, but you never know with Access.
>
> Thank you,
>
> Brandon
> --
> --------------------------------------------
> Database Administrator
> bkc5 AT CDC dot GOV
>
> "Rick B" wrote:
>
> > Are each of your users working on their own copy of the front-end database?
> >
> > If not, you should split your database.
> >
> > Rick B
> >
> > "Brandon Campbell" <BrandonCampbell@discussions.microsoft.com> wrote in
> > message news:E4F6C1F2-B702-4A4E-AA29-ABED20493980@microsoft.com...
> > 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,
> > --
> > --------------------------------------------
> > Database Administrator
> > bkc5 AT CDC dot GOV
> >
> >
> >

Relevant Pages

  • Searching in a Memo Field
    ... The problem is that when a user does a search, they receive a warning that they are trying to update a record that another user has open. ... How can I search a Memo field when other users are in the database??? ... This was never a problem on SQL Server. ... Database Administrator ...
    (microsoft.public.access.formscoding)
  • RE: Queries
    ... "Brandon Campbell" wrote: ... > Database Administrator ... > bkc5 AT CDC dot GOV ...
    (microsoft.public.access.queries)