Hello.
(I am not good at English.^^)
Help me.
I moved the database. (B Server -> A Server)
There was nothing wrong with the "B" server.
Look at the next picture.
"tech_keep_t" table and "tech_keep_t-2" table are the same.
The "tech_keep_t-2" tables connected to the "B" server are normal.
The "tech_keep_t" table connected to the "A" server has an error.
1) I opened the "tech_keep_t" table.
2) I modified a record. : normal
3) The record was moved last.
4) I modified a record. : error
The "tech_keep_t-2" table is normal
Therefore, I think there is a problem with the setting of the server.
The following attachment is the setting for both servers.
What is the solution?
CF.
MS-Access Setting
- Basic Open : Sharing mode
- Default record lock : Do not lock
- Record-level locking : check
(I am not good at English.^^)
Help me.
I moved the database. (B Server -> A Server)
There was nothing wrong with the "B" server.
Look at the next picture.
"tech_keep_t" table and "tech_keep_t-2" table are the same.
The "tech_keep_t-2" tables connected to the "B" server are normal.
The "tech_keep_t" table connected to the "A" server has an error.
1) I opened the "tech_keep_t" table.
2) I modified a record. : normal
3) The record was moved last.
4) I modified a record. : error
The "tech_keep_t-2" table is normal
Therefore, I think there is a problem with the setting of the server.
The following attachment is the setting for both servers.
What is the solution?
CF.
MS-Access Setting
- Basic Open : Sharing mode
- Default record lock : Do not lock
- Record-level locking : check