Go Back   Access World Forums > Apps and Windows > SQL Server

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-13-2019, 10:02 PM   #1
munhun
Newly Registered User
 
Join Date: Nov 2018
Posts: 4
Thanks: 2
Thanked 0 Times in 0 Posts
munhun is on a distinguished road
There is a writing conflict issue.

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
Attached Files
File Type: zip img.zip (1.39 MB, 29 views)

munhun is offline   Reply With Quote
Old 01-14-2019, 12:24 AM   #2
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 8,309
Thanks: 99
Thanked 2,129 Times in 1,978 Posts
isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light
Re: There is a writing conflict issue.

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
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
munhun (01-14-2019)
Old 01-15-2019, 09:50 AM   #3
bastanu
Registered User
 
Join Date: Apr 2010
Location: Kelowna, Canada
Posts: 220
Thanks: 1
Thanked 60 Times in 60 Posts
bastanu is on a distinguished road
Re: There is a writing conflict issue.

Looks like you are working with MySQL servers, in addition to Colin's suggestion to set the defaults for the bit fields can you try to add a timestamp field to the table:https://stackoverflow.com/questions/...-linked-tables

Cheers,
Vlad

bastanu is offline   Reply With Quote
Reply

Tags
recordlockingwithaccess , writeconflict

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Write Conflict TroyT Modules & VBA 2 03-02-2016 02:58 PM
Writing to Table Issue Djblois Tables 4 08-13-2009 10:04 AM
2 versions of Access conflict issue russi General 6 11-18-2008 06:12 AM
write conflict issue mazza Modules & VBA 0 01-25-2008 08:52 AM
Matching fields and writing to table issue KCK Forms 0 08-30-2006 06:46 AM




All times are GMT -8. The time now is 05:22 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World