question

TammyLaw-2953 avatar image
0 Votes"
TammyLaw-2953 asked KenSheridan-7466 edited

Access 2019

Access 2019 version.

In the table, I'm trying to set the primary key as the first row, but it keeps telling me that it won't accept it when I go to save it. What can cause this and how can I fix it? I can't save the table until it's solved. Thank you.

office-access-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

thedbguy avatar image
0 Votes"
thedbguy answered

Can you post some screenshots?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KenSheridan-7466 avatar image
0 Votes"
KenSheridan-7466 answered KenSheridan-7466 edited

Does the table already have any data? The two preconditions of a column being the primary key are:

 The values in the column must be distinct.
 The column position cannot be Null (empty) in any row.

If the table has any data does it conform to the above. Also, the column cannot be a long text data type of course.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.