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 ?
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 pleaseRe:although ntdll.dll is found OK in C:\WINDOWS\SYSTEM32\ntdll.dll)？
I find this post has been marked anwsered.
But from the latest post,the question still exists.
Should it use ODBC only?
Why not try export .csv and then import to My Sql?
- there is no csv export in MS-Access menus
anyway, it's much more simple to export directly with ODBC
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)
