Re: MSAccess: Too many fields defined when trying to add column

It's clearly not the table definition that's the problem. It sounds
like it's corrupted - maybe even the entire database is corrupted. If
you've already compacted and repaired, try this: rename the table and
create an entirely new table with the same schema. Write an append
query to load the data. To be really safe, create an entirely new
database and import the good tables, leaving out the bad table. Then
recreate the bad table and load the data. FWIW, error messages can't
always be taken literally. When you have a totally illogical message
like that, you know something else is going on.

-mary

On Wed, 11 Jul 2007 18:29:37 +0100, "Keith Sheppard"
<keith.sheppard@xxxxxxxxx> wrote:

I am using Access 2000 (9.0.3821 SR-1).

One of my access database tables seems to have developed a bizarre problem
that I cannot add columns to it. I have tried both programatically with a
query string of the form:

ALTER TABLE MasterPoints ADD COLUMN fred Double

And I've tried doing it in design view. In both cases, I get the error
response: "Too many fields defined" (in design view the error doesn't appear
until you try to save your changes). What? The table only comprises 11
columns so what does "Too many fields defined" mean?

I have even tried removing one of the existing columns (works OK) and then
when I try to re-add the same column back in and I get the "Too many fields
defined" error. The problem only affects this specific database table. I
can add columns to other tables without any difficulty.

Perhaps even more bizarrely, I have a backup of my database dated 26th June
07. I can add columns to the same table in this fortnight old backup
without problem so something, I've no idea what, has happened to the
database in the intervening two weeks.

Any suggestions? In case it's relevant, the current columns in the table
are:
ID AutoNumber
MembershipNumber Long
NonMemberName Text(100)
CompetitionID Long
MasterPoints Single
Status Long
DateCredited Date/Time
RecordUpdated Yes/No
Colour Long
SessionNo Long
MPTotalsString Memo

Keith

.

Relevant Pages

  • C# programmer looking for a job
    ... Software Development including Desktop, Client/Server and Database ... Practical skills in object oriented design and design patterns ... XML, Oracle, CVS, VSS, Delphi, bug tracking. ... Developed in Delphi5; ...
    (misc.immigration.usa)
  • Re: O/R Mapper
    ... | - create E/R model from niam model ... classes that contain, not only data, but also functionality as OO design is ... a database where they do not exist in the object model is corrupting the ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Date range on reports
    ... > box to your report with a control source like: ... >> In the Database window (Database window: The window that appears when you ... >> In the New Form dialog box, click Design View, and click OK. ... >> Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)
  • Re: limit of lines?
    ... And this is the fundamental mistake in your design. ... a objects from a database, this usually leads to very poor design. ... Framework in which all properties are backed, not by a simple field, but by ... we have major size projects that use the Delphi template ...
    (borland.public.delphi.non-technical)
  • Re: O/R Mapper
    ... > as OO design is not just about data in isolation. ... the proper tooling/methods are used which fit with the approach chosen. ... >> of the reality to come to the proper result. ... > constraints into a database where they do not exist in the object ...
    (microsoft.public.dotnet.languages.csharp)