'Exceeds the limit of 1,000 row (actions) for a macro' but does not apply!

[russi]

Hi.
I have a table used for years. I added new fields bringing number to 160.
When I go to insert another row, I get message saying 'Row inserted in the grid exceeds limit of 255 rows for table or 1,000 rows (actions) for a macro.'

BUT as the number of records had not increased and I am under the 255 limit why the error message?

I tried in vain to copy and compact/repair the database, but still no luck.

Ideas?

Russ

 

[Rich]

try creating a new table and pasting the records into it, you may have to paste a smaller amount of records at a time

 

[russi]

No go on these ideas. But thanks for trying.

Any more ideas????

Russ

 

[Bat17]

Are most of the fields indexed? I have a feeling at the back of my mind that each index takes another field. Can't remeber where I got that from but will try to find a reference.

Peter

Ignore that, with a max 32 index it is not enought to make the difference! Peter

 

[russi]

Thanks for the try, but no go.
I only have a few records indexed and I just tried getting rid of that and compacted and repaird and
Still No Go!!!


Russ

 

[russi]

By the way, there are no macros, and I deleted table relationships and still nothing. I cannot add fields to the table and there are only 175 fields.

Russ

 

[Bat17]

Have you deleted fields in the table before? It might be worth trying to import the table to a new db to play with. I knew Forms kept track but did not realise other objects might. see
http://www.access-programmers.co.uk/forums/showthread.php?t=88519

HTH

Peter

 

[Bat17]

Just had a play and hit too many fields, but copying and pasting the table was enough to clear the memory.



Peter

 

[ghudson]

Compacting the db should clear out the old [deleted] objects since Access stores [but not in a usable or retrievable format] the deleted info.

 

[russi]

Sorry folks, but none of these suggestions worked.

More ideas?
Russ

 

[The_Doc_Man]

By any chance is this an EXCEL-based table that is linked to Access? If so, you have reached an EXCEL limit, not an Access limit. Try looking up "LIMITS" or "SPECIFICATIONS" in EXCEL to see what their limits are.

What is suddenly bothering me after reading this again is that Access would NEVER use the term "255 ROWS" in an error message because it doesn't have anything that measures data in units of rows that could approach 255 of them.

All Access ever uses would be called records. The query grid would drop dead after a lot fewer than 255 rows in the design view of that grid but it has essentially NO limits on the number of rows it could display once in datasheet view. Now, if you had more than 255 fields, that could do you in. OR is there a chance that one of your records exceeds the 2048-character limit? No record can exceed 2048 characters. I could imagine Access being confused about what it wants to tell you.

Another question is, have you checked your references lately? This COULD be an incredibly obscure issue with a broken reference. Search this forum for "References" if you don't understand what I am suggesting here.

 

[russi]

DocMan,

Thanks for replying.

No, this is not Excel-related or base.

The message is: 'Row inserted in the grid exceeds limit of 255 rows for table or 1,000 rows (actions) for a macro.'

Again, there is no macro here in the be file of this split datafile. And I am only working on the be, directly.

I checked references and nothing that I can tell is wrong.

If I delete fields, then I can add but only on a 1-for-1 basis. Or if I truncate a field size, I might get another field to take. But this is crazy, esp. as no record comes close to having all fields filled-in or at least with the maximum possible answers.

Ideas?

russ

 

[ghudson]

Not sure of the version of Access you are using but your version of Access thinks you have exceeded your max number of fields. 160 still sounds like a lot of fields. Is your table [database structure] normalized?

 

[Bat17]

Are you getting this error when you try to add data or a new field?
This still happens when you import the table to a new DB?

can you strip out the data and post just the new db with that table here so that we can look at it for you?

Peter

 

[russi]

Hi.
I am using Access 97.
It happens when adding fields. Right now you can add one field , but when you go to do another, you get the problem.

I have stripped out the data and am including the database. - Note that the table that I am having trouble with is called CLIENT BASIC INFO. It is so large basically to make it easier to provide our training agencies data requests. And I have over 500 reports based upon the current layout so re-doing it now would be a large issue. - This is the back end of a split database. But I have the problem working with the back directly. - I have also tried removing relationships from that table, just to see if that made a difference and it does not.

I appreciate possible solutions to and an explanation for this problem.

Russ
I appreciate any help.

 

[Bat17]

I have a table used for years. I added new fields bringing number to 160.
When I go to insert another row, I get message saying 'Row inserted in the grid exceeds limit of 255 rows for table or 1,000 rows (actions) for a macro.'

I just counted the fields and you have 254 not 160! you have reached the limit for the table.

You could create another table with a 1 to 1 join but a query will limit you to 255 fields when you join them. If you only use subsets of the data though this will work.

HTH

Peter

 

[russi]

How embarrased.
Can I dig a hole large enough?
Working with multiple copies, I was counting with the wrong one.

I couldn't find a deep enough shade of red to turn.....

Russ

 

[BenAlc]

Hi.
I have a table used for years. I added new fields bringing number to 160.
When I go to insert another row, I get message saying 'Row inserted in the grid exceeds limit of 255 rows for table or 1,000 rows (actions) for a macro.'

BUT as the number of records had not increased and I am under the 255 limit why the error message?

I tried in vain to copy and compact/repair the database, but still no luck.

Ideas?

Russ

Did you find the solution to this problem? I have similar issue when inserting rows... exceeding 255

 

[BenAlc]

Russ,
Did you find the solution to this problem? I have encountered similar issue. Thx

 

[CJ_London]

You are responding to an 8 year old post - it is possible the posters are no longer on this forum.

Suggest you start a new thread specific to your problem.

If your problem is that you want a table with more than 255 fields then the only way to do it is to split the table into two or more tables, all linked using a 1 to 1 relationship. However it does beg the question whether you have your tables designed properly, I've yet to see a situation where this number of fields are actually necessary.