«

Hi,

I'm using the querybuilder when updating a record in a table (Access).
However, I get a "Query is too complex" message.

The Primary key is autonumbered.
Why is it making such a complex update query string in stead of using the
primary key?

Thanks in advance,
Ben

can you give an example?

Also i think that maybe this would be better posted on one of the sql
groups.


"Ben de Vette" <> wrote in message
news:...
> Hi,
>
> I'm using the querybuilder when updating a record in a table (Access).
> However, I get a "Query is too complex" message.
>
> The Primary key is autonumbered.
> Why is it making such a complex update query string in stead of using the
> primary key?
>
> Thanks in advance,
> Ben
>
>

Darren,

you are right it concerns a SQL statement, but in this case it is the
querybuilder making a very complex sql statement while it can use the
primary key to select the Record.

With kind recards,
Ben


"Darren Clark" <> wrote in message
news:...
> can you give an example?
>
> Also i think that maybe this would be better posted on one of the sql
> groups.
>
>
> "Ben de Vette" <> wrote in message
> news:...
> > Hi,
> >
> > I'm using the querybuilder when updating a record in a table (Access).
> > However, I get a "Query is too complex" message.
> >
> > The Primary key is autonumbered.
> > Why is it making such a complex update query string in stead of using
the
> > primary key?
> >
> > Thanks in advance,
> > Ben
> >
> >
>
>