Is there a way to look at the internal column count that Access uses?

[rlh145]

The reason I am asking this is that I am getting a "Too many fields defined" error when I run a Microsoft Frontpage application to update an Access database. I have removed fields and reduced the field's size appropriately. I have saved the table to another name; removed the original table and renamed the saved table. I have also done the 'compact and repair database'. Yet I still get this error.

If anyone has any other ideas on why I still get this error, I would appreciate it!

Ralph

 

[thornmastr]

This might help.



The internal column count that Microsoft Access uses to track the number of fields in the table has reached 255, even though you may have fewer than 255 fields in the table. This can happen because Microsoft Access does not change the internal column count when you delete a field. Microsoft Access also creates a new field (increasing the internal column count by 1) for every field whose properties you modify.

To free the internal column count for deleted fields or for fields whose properties you modify, do one of the following:
In Microsoft Access 7.0 or 97, click Save As/Export on the File menu and save the table under a different name. Then, delete the original table and rename to new table to the original table name.

WARNING: Clicking Save As on the File menu in version 1.x or 2.0 copies only the structure of a table, not the records. Do not delete the original table until you use an append query to populate the new table.
In Microsoft Access 1.x or 2.0, click Save As on the File menu and save the table under a different name. Populate the new table with data from the original table. Then, delete the original table and rename to new table to the original table name.

You can also free the internal column count by compacting the database.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com