ODBC Error Code = S1001 (Memory allocation error)

[Joe M]

Using Macromedia Cold Fusion to update an MSAccess 2000
database table.

I get the error message: "ODBC Error Code = S1001 (Memory
allocation error) [Microsoft][ODBC Microsoft Access
Driver] Too many fields defined."

Is there a maximum number of fields limitation or is there
something else going on... there are 142 Fields defined in
the database.

Thanks

 

[[MVP] S. Clark]

Access has a 255 field limit per table, but you can have multiple tables per
database.

142 fields in one table seems like a lot. Try breaking it down and see if
the error stops.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-