Re: Limit on Access where clause?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi, the original thread I saw was dated 11/8 and titled "DataTable on
MSAccess Table with 100+ fields". Seems that CommandBuilder and (I would
assume) TableAdapter both create where clauses matching every field on the
table to handle concurancy issues. The original thread simply stated that
the update failed. Guess this means that you will have to write your own
update sql for Access tables with greater then 99 fields.
--
Terry


"Michel Posseth [MCP]" wrote:

hmmm ,,,,,, funny


Microsoft Access query specifications Attribute Maximum
Number of enforced relationships 32 per table minus the number of
indexes that are on the table for fields or combinations of fields that are
not involved in relationships
Number of tables in a query 32
Number of fields in a recordset 255
Recordset size 1 gigabyte
Sort limit 255 characters in one or more fields
Number of levels of nested queries 50
Number of characters in a cell in the query design grid 1024
Number of characters for a parameter in a parameter query 255
Number of ANDs in a WHERE or HAVING clause 99
Number of characters in an SQL statement Approximately 64,000


however the oledb command object does not point to anny limitations in the
documentation other as the max string size , i also wonder what would
happen with the "WHERE IN " QUERY if you would go beyond the 99 limit

Michel




"Terry" <TerryL@xxxxxxxxxxxxx> schreef in bericht
news:F86AB8CB-4D64-41C5-A9B0-2BEE575302EC@xxxxxxxxxxxxxxxx
I saw a thread on this group in the last week or so that indicated that
Access had a limit of 99 fields in the where clause.
--
Terry


"BobAchgill" wrote:

Is there a resource limit on how many items can be put in the Where
clause of
a select command that retrieves rows to a OleDbDataAdapter dataset? Can
it
be unlimited if I change some settings?

I bumped my head when I got to ...
SELECT col1 col2
FROM table
Where this0 AND that0 AND it0
OR this1 AND that1 AND it1
...
OR this97 AND that 97 AND it97

Thanks!

Bob



.

Relevant Pages

  • Re: Syntax error in FROM clause
    ... > following syntax by using the design grid and typing into the SQL ... FROM clause) does not appear to be closed, that is, there is a starting "[", ... I too would not use special characters on a Column-name alias (or spaces ... query against your will. ...
    (microsoft.public.access.queries)
  • Re: WSS is PATHETIC if users can create duplicate entries with accidental clicks!
    ... This command ONLY shows the last 10 characters of content. ... Add a new content webpart for easy finding. ... With your query I should see the text in the ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Wont allow additional code??
    ... >and click on various command buttons to view various reports. ... >the query is included within the code of each command button. ... >characters into the code. ...
    (microsoft.public.access.formscoding)
  • Re: Limit on Access where clause?
    ... When you do write that query when you do manage to that is be kind enough to post it so we can have a look. ... Number of characters in a cell in the query design grid 1024 ... > Access had a limit of 99 fields in the where clause. ... >> a select command that retrieves rows to a OleDbDataAdapter dataset? ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Query Based on Time Rane and Date Range
    ... I want to put this into a command button. ... What is the correct Syntax ... This is the WHERE clause of a Query; it is not VBA code, ...
    (microsoft.public.access.queries)