A2SS0024: Table does not have a primary key or unique index and therefore cannot be edited from within Access.

[Nick]

A2SS0024: Table does not have a primary key or unique index and therefore
cannot be edited from within Access.

I get this message from SSMA for some tables in my mdb. The end result is
that these tables are not upsized. Odd thing is other tables with the exact
same columns are upsized without error. Typically, a timestamp column is
append to the table. How do I upsize tables when message A2SS0024 occurs?

[Tony Toews [MVP]]

Post by Nick
A2SS0024: Table does not have a primary key or unique index and therefore
cannot be edited from within Access.
I get this message from SSMA for some tables in my mdb. The end result is
that these tables are not upsized. Odd thing is other tables with the exact
same columns are upsized without error.

But do those tables have a primary key? Go into the tables design
view and poke about. See if you can see the key symbol beside a
field, etc, etc.

For example there may very well be an autonumber field but maybe it
isn't a primary key. For whatever reason lost in the mists of
history.

Tony

[Nick]

Thank you for your help.

The only difference between the table definitions for the ones that SSMA did
upsized without error is that they are all linked tables. The upsized linked
tables are stored in another mdb. I will try moving the tables that are in
error and linking them to test.

Post by Tony Toews [MVP]

Post by Nick
A2SS0024: Table does not have a primary key or unique index and therefore
cannot be edited from within Access.
I get this message from SSMA for some tables in my mdb. The end result is
that these tables are not upsized. Odd thing is other tables with the exact
same columns are upsized without error.

But do those tables have a primary key? Go into the tables design
view and poke about. See if you can see the key symbol beside a
field, etc, etc.
For example there may very well be an autonumber field but maybe it
isn't a primary key. For whatever reason lost in the mists of
history.
Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/

[Tony Toews [MVP]]

Post by Nick
Thank you for your help.
The only difference between the table definitions for the ones that SSMA did
upsized without error is that they are all linked tables. The upsized linked
tables are stored in another mdb. I will try moving the tables that are in
error and linking them to test.

Ok, that would make a lot of sense.

Tony