About the first-aid problem that the connection table data cannot be modified after the connection problem of sql and ac

lbeast001

In SQL, set the id of a table as the primary key, and it is automatically numbered, the ID is incremented by 1. Then connect to the table in access, add additional database query results to the connected table by appending queries, and then open The connection table found that all records could not be changed, deleted, or added, prompting "The Microsoft Jet database engine stopped the process because you and other users tried to change the same data at the same time." However, if you manually enter data into the connection table, the above problems will not occur. Please enlighten me.

lbeast001

Just try it yourself

小老鹰

Compression fixes MDB
Check if the background auto-numbering field is an int or bigint?

lbeast001

I used int, which is still useless after compression repair. I don't know why?

ilgold

I have n’t encountered it before.