Access 2019

Tammy Law 1 Reputation point
2021-09-26T23:32:51.22+00:00

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.

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
823 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. DBG 2,301 Reputation points
    2021-09-27T05:07:08.427+00:00

    Can you post some screenshots?

    0 comments
  2. Ken Sheridan 2,666 Reputation points
    2021-09-27T17:00:29.133+00:00

    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.

    0 comments