Forum Discussion
Solved
export table with ODBC to MySQL crashes
hello I have 2 PC's : one old HP Pavillon, 1 new MS Surface with same configuration : W10 - MS-Access - Wampserver with local MySQL connection to MySQL with PhpAdmin is OK on both, same privileges...
fy : I re-installed windows 10 and everything runs OK now.
(I assume module ntdll.dll has been corrupted, and re-installing W10 was the only solution)
add info :
my user 'root'@localhost has 'lock table' privilege unchecked
is this the reason of the crash ?
when i try to check 'lock table' privilege, i receive this error msg
#1045 acces denied for user r 'root'@localhost '(using pw NO)
please, help !
my user 'root'@localhost has 'lock table' privilege unchecked
is this the reason of the crash ?
when i try to check 'lock table' privilege, i receive this error msg
#1045 acces denied for user r 'root'@localhost '(using pw NO)
please, help !
- add info:
I re-installed Wampserver with full MySQL privileges.
MS-Access still crashes when exporting a table via ODBC, despite Test result is "OK".
Crash occurs with my MS Surface and not with my HP Pavillon, although the MS-Access and WampServer are strictly the same.
Could the problem be linked with any SMS-Surface configuration issue ?- following my previous question : MS-Access Crashes and closes when exporting a table to MySQL via ODBC
there is nothing in MS-Access log
Windows log says :
application défaillante MSACCESS.EXE, version : 12.0.4518.1014, horodatage : 0x4542815c
module défaillant : ntdll.dll, version : 10.0.19041.4842, horodatage : 0xaabba71d
Code d’exception : 0xc0000374
(although ntdll.dll is found OK in C:\WINDOWS\SYSTEM32\ntdll.dll)
my config =:W10 22H2 - MS-ACCESS 2004- ODBC 3.51 - MySQL 8.0
help please
