There is a writing conflict issue. (1 Viewer)

munhun

New member
Local time
Today, 05:05
Joined
Nov 23, 2018
Messages
8
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
 

Attachments

  • img.zip
    1.4 MB · Views: 144

isladogs

MVP / VIP
Local time
Today, 12:05
Joined
Jan 14, 2017
Messages
18,186
I don't really understand what your pictures show but the problem may be with bit fields in sql server.
See this article on my website Write Conflict Errors
 

Users who are viewing this thread

Top Bottom