Forum Discussion
Can not enter new record via Access front end after linking tables to SQL Express
I have a Time & Billing Access program. I just migrated the tables to a SQL Express database and using it as the back end: tables all linked to the front end Access program. With my Access front ...
malcolm_p_galvin_jr , MS Access as frontend has an important restricts, a table must (!!!) have a primary key, otherwise you can't edit any data in the table.
Do the table have a PK?
Spot on! Thanks for the answer!
I had an original program in which that table did have a PK. I copied that program to use with another user and at some time changed the table to eliminate the PK. I used the changed program database tables to migrate to SQL. I will now use the original program, with the PK in the table, and do a new migration to the SQL.
I had an original program in which that table did have a PK. I copied that program to use with another user and at some time changed the table to eliminate the PK. I used the changed program database tables to migrate to SQL. I will now use the original program, with the PK in the table, and do a new migration to the SQL.