I have an Access97 table that contains approximately 240 fields, which has been functioning just fine. When I changed the data type of several of these fields from Date/Time to Text, and then attempted to save this file, I got, "Too many fields defined. You tried to perform an operation that involves more than 255 fields. Reduce the number of fields, and then try the operation again." I let the table go unsaved, and opened it again, and changed a single field, and got the same message. Next I copied just the structure of that table to a new table name, opened it changed one field and saved it OK. But when I continued down through the fields attempting to save each change as I went, I still got that error. Any ideas?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.