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 problem i have is when i quickly change some records in the table, i'm recieving a writing conflict (caused by a recordlock), if i wait a short time i can change it,
if i'm using heidiSQL to change the data directly in the table there is no record lock , so i'm almost confinced the problem is in the odbc connector.
does anyone has a tip or solution for this problem?
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 problem i have is when i quickly change some records in the table, i'm recieving a writing conflict (caused by a recordlock), if i wait a short time i can change it,
if i'm using heidiSQL to change the data directly in the table there is no record lock , so i'm almost confinced the problem is in the odbc connector.
does anyone has a tip or solution for this problem?