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
when I try to export a table from MS-Access to MySQL with ODBC (port 3306, user=root, pw blank)
- it works on my HP Pavillon
- it crashes with my MS Surface:
. with option 'test', I receive the msg 'connexion successfull'
. when clicking 'OK', the process seems to run for a few seconds, then stops and MS-Access closes
. the log file 'myodbc.sql' is created but is empty
any suggestion ?
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)
6 Replies
- 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 !- 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