Update Query Field Limits !!!

[SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD.]

Dear Sir,

I am using Visual Basic 6, Microsoft Access 2000 & ADO 2.5.

In my table there are 140 fields. I am Using UPDATE Query to Update Value of
Fields & INSERT Query to Insert Record in Table. I Update & Append only one
single record in one table.

If I Insert Record using INSERT Query then it is Inserting Record Property
with proper Value in all fields.

But When I try to Update Values of Fields using UPDATE Query then it display
error message Too Many Fields Defined. If I reduce fields from 140 to 125
then it works fine in Update Query.

If I try to Open Recordset & Replace Value & Update using Update method then
it is not working for more than 113 fields.

I know there is limitation of 255 fields in Table & Query. Then why it is
giving only in 140 fields.

Is any one know this issue ?

Sanjay Shah

 

[John Spencer]

Only a guess but 140 fields in the table to be updated and 140 fields in the
table that is the source for the update is 280 fields (or more than 255).


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD.]

Hi John,

I am using Parameters to Update Values or Insert Record in Table.

If Query is counting 140 fields of source. Then why it is working properly
in INSERT query.

If you don't know exact reason please do not bluff. Please try to find
proper reason.

Sanjay Shah

 

[John Spencer]

One, as I clearly stated "ONLY A GUESS"

Since you did not post enough details to make anyting but a guess. I
guess I will drop out of this discussion and you can attempt to continue
on your quest to find a solution.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================