Error on Select Query

  • Thread starter Thread starter Leif
  • Start date Start date
L

Leif

I'm trying to do a select query that has 36 fields and 18
comparisons in the WHERE clause. When I run the query I
get the message:

"The Microsoft Jet Database Engine stopped the process
because you and another user are attempting to change the
same data at the same time."

However, I'm not trying to change data, I'm doing a select
query. However, if I delete 4 fields and 2 WHERE clauses
from my query it runs OK.

I'm I hitting some internal Microsoft SQL limitation?
Perhaps max SQL size, or number of columns, or number of
comparisons in a WHERE clause?

Thanks,
Leif
 
Hi,

You are limited to 255 fields, and around 2000 characters per record
(total of all non-OLE and non-memo fields). Take a look at "Access
specifications", in the help file, to know the limits of your version.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top