table corruption

  • Thread starter Thread starter mark R.
  • Start date Start date
M

mark R.

I took some advice I recently received (several times) and
identified about 35 fields out of 215 that I
could "normalize" and put into another table (out of my
original table), utilizing subform with those 35.

I needed to replacce those 35 fields with 10 new ones (a
savings of 25 fields).

I used the delete rows right click and deleted those 35
fields. Then when I went to add one (my total is now les
than 180 fields) I got an error , too many fields.
I knew this was not true, so I investigated field by
field. To make a long story a little short, I eventually
found that if I deleted one particular field named "K_",
I no longer got the error message. I have since added 45
fields and still no problem.

Should I assume ACCESS fixed the problem, or after my
prototype is finished, should I delete the whole test
table and retype it in from scratch, with no data in it at
all, and start the actual live beta test with a fresh
table?
 
Hi,

The maximum number of fields, 255, is for the life of the table (that count
may be reset if you compact, I am not 100% sure on that specific, on the
other hand), in other words, the deleted field still count against that
maximum.


Hoping it may help,
Vanderghast, Access MVP
 
Well, it begins to help. I do not know how to "compact".
Otherwise, it sounds like I have to retype all my fields
into a new table and start my table from scratch, so that
any deleted fields "do not count against my total"

Can any one give me more explicit guidance?
 
Tools | Database Utilities | Compact.

Compacting is something that should be done regularly to all databases.
Space inside the MDB file is not reclaimed unless you compact.
 
Back
Top