With I cant Update a MS ACCESS Table with more than 40 fields using ODBC

Flavio Kiipper

Delphi Developer

Sat, 01 May 2004 07:07:11 GMT

With I cant Update a MS ACCESS Table with more than 40 fields using ODBC

I'm using ODBC and BDE.

If the MS ACCESS has less than 41 fields (i.e. 40 Fields) my program can edit/post or delete de record, BUT if the MS ACCESS table has 41 fields, i receive a message:

SQL is too complex.

Help, please.

Brian Bushay Team

Delphi Developer

Sat, 01 May 2004 11:47:31 GMT

Re:With I cant Update a MS ACCESS Table with more than 40 fields using ODBC

Quote

>If the MS ACCESS has less than 41 fields (i.e. 40 Fields) my program can edit/post or delete de record, BUT if the MS ACCESS table has 41 fields, i receive a message:
>SQL is too complex.

Change the UpdateMode to UpdateWhereKeyOnly
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Other Threads

1. Q: Memo fields Delphi 1 using MS Access 2.0 tables through ODBC

2. Update an record needs 40 Seconds with Access 97

3. Blob field in a table: cant access table

4. MS-ACCESS Tables Description (using ODBC)

5. Connecting to an Access table with a memo field using ODBC

6. Accessing MS-Access 2.0 DB using ODBC

7. D5-ADO-MS ACCESS 97 database-MS Office 97 Access ODBC driver-Autoincrement probs

8. Problem accessing MS Access odbc database after installing MS SQL7

9. Problems accessing an ACCESS-Table using ODBC and SQL

10. Updating a table with a field from another table using Interbase