| |

VerySource

 Forgot password?
 Register
Search
View: 15|Reply: 4

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

[Copy link]

1

Threads

4

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

Post time: 2020-1-3 14:50:01
| Show all posts |Read mode
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.
Reply

Use magic Report

1

Threads

4

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

 Author| Post time: 2020-1-3 14:51:01
| Show all posts
Just try it yourself
Reply

Use magic Report

0

Threads

20

Posts

12

Credits

Newbie

Rank: 1

Credits
12

 China

Post time: 2020-1-3 22:42:01
| Show all posts
Compression fixes MDB
Check if the background auto-numbering field is an int or bigint?
Reply

Use magic Report

1

Threads

4

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

 Author| Post time: 2020-1-25 14:36:01
| Show all posts
I used int, which is still useless after compression repair. I don't know why?
Reply

Use magic Report

0

Threads

5

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

Post time: 2020-5-31 02:00:01
| Show all posts
I have n’t encountered it before.
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list