Recent content by JohanS

its also the same for a string ... as soon as the data is the same (for example i retype exact the same characters over the current record) it throws a write conflict ... so luckely its not a big issue ... but i do find it a strange error, why can't it update a record when the data stays the...

Yes i have exact the same settings, oh and i use a USER-DSN instead of a FILE-DSN don't know if this is something that could do something with the problem

i just found out what triggers the write conflict ... when I change my 'selection' column (which contains a 0 or a 1) and change the data from 0 to 1 there is no problem, but when i go over the table and change it from a 0 to 0 (so actually no change) it gives me the error i have made a short...

First of all, let me say, what an incredibly active forum ... within days and already so much reactions... 👏 i just have tried some other refresh intervall settings, but unfortunatly no difference in the fault. The recordlock setting is turned to 'no record lock', but the checkbox below this...

Yes i have set a primary key INT (auto increment)

i think you mean the file --> options -->clien settings --> no record lock setting?

@Minty , Thanks for the input, i have changed to this driver, but the result is the same. @theDBguy, i was changing the data, opened the RAW table in Msacces, and was changing some 0 to 1 from some records going down, and after this going up and changed them back to 0. not all records gives...

Hello Guy's I want to migrate our complete MsAccess database to mariaDB. I have already running debian with mariaDB on premises, and have already made a new table in it. (and coupled it to my MSaccess frontend no problems there.) I'm using ODBC driver MySQL ODBC 8.0 ANSI driver. the...