Re: Too many fields?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "George Nicholson" <GeorgeNJunk@xxxxxxxxxxx>
Date: Tue, 5 Jun 2007 12:33:25 -0500

Tools>Utilities>Compact and Repair

Deleting fields doesn't free diskspace or remove them from the field count
until you do a Compact.

HTH,

"Tomtheappraiser" <Tomtheappraiser@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:32688036-6C7D-49A8-A077-D49C91F044D7@xxxxxxxxxxxxxxxx

In my databse I was try to add a field, and it said that I have too many
fields. But when I went and deleted one that I never use, it still says I
have too many. Even if I go to one and change the name and properties of
an
existing field, it wont let me save.

Can anyone help with this?

Follow-Ups:
- Re: Too many fields?
  - From: RBear3

Prev by Date: Re: Dependant's Table
Next by Date: Re: One Master LU Table vs. Many LU Tables
Previous by thread: Re: To .Close or not to .Close
Next by thread: Re: Too many fields?
Index(es):
- Date
- Thread

Relevant Pages

Re: "There isnt enough memory to perform this operation"
... Our method of dealing with the problem so far is saving a lot and Compact & ... leaving Design mode. ... Run Compact & Repair on one of the copies. ... large app -- about 72 MB of program with tables linked to another Access ...
(microsoft.public.access.tablesdbdesign)
Re: #Name? error
... Have you done a compact and repair, or a decompile followed by compact and ... What happens if you create another database as a test, keep it simple, use ... Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia ...
(microsoft.public.access.forms)
Re: Form Dirty not firing
... also forces me to do a backup and compact and repair again. ... MISSING references. ... Database Utilites... ...
(microsoft.public.access.formscoding)
Re: Re-ordering of Tables
... clustered index (MSDE) then that is the exception. ... In the case of a compact and repair, the rows added subsequently would not ... clustered index but that has nothing to do with the question at hand. ...
(microsoft.public.access.tablesdbdesign)
Re: linked table problem and need advice
... It probably was a corruption problem that you probably fixed with the ... I'd run the Compact and Repair a few more times to be ... If you do decompile, make sure to have a backup copy. ...
(microsoft.public.access.gettingstarted)