Hi,
Windows 10 - 64 bit
MS Access 10 - 32 bit
ODBC connection - 32 bit
I had an MS Access database as a front end & MYSQL as the backend. Had created the connection successfully.
I have a form, which records a particular transaction. However, the transfer of the data from local table & then move the same to Linked table from MySQL server.
\\\Quote\\\
Sub uploadSQL()
Dim conn As ADODB.Connection
Dim sqlstr As String
Dim RS As ADODB.Recordset
Dim Crow As Long, Lrow As Long
Dim Item As String, Price As Long, weight As Long, category As String
Set conn = New ADODB.Connection
conn.ConnectionString = "DRIVER={MySQL ODBC 8 ANSI Driver};" _
& "SERVER=10.91.10.60;" _
& "DATABASE=xxxxxxx;" _
& "UID=xxxxx;PWD=xxxxxx;"
conn.Open
sqlstr = "INSERT INTO `Ticket Master`(`EDI Ref`,`Booking Office`,`Date Received`,`Time Received`,`Processed by`,`Date Completed`,`Time Completed`,`Booking Number`,`Date Started`,`Time Started`,`Request Status`,Query_Type2,Query_MSG2,`Query_Start-2`,`Query_End-2`,Query_Type3,Query_MSG3,`Query_Start-3`,`Query_End-3`,Query_Type4,Query_MSG4,`Query_Start-4`,`Query_End-4`,Query_Type5,Query_MSG5,`Query_Start-5`,`Query_End-5`,Request_Source,Amendment_Type,ReStart_1,ReStart _2,ReStart_3,ReStart_4)SELECT (`EDI Ref`,`Booking Office`,`Date Received`,`Time Received`,`Processed by`,`Date Completed`,`Time Completed`,`Booking Number`,`Date Started`,`Time Started`,`Request Status`,Query_Type2,Query_MSG2,`Query_Start-2`,`Query_End-2`,Query_Type3,Query_MSG3,`Query_Start-3`,`Query_End-3`,Query_Type4,Query_MSG4,`Query_Start-4`,`Query_End-4`,Query_Type5,Query_MSG5,`Query_Start-5`,`Query_End-5`,Request_Source,Amendment_Type,ReStart_1,ReStart _2,ReStart_3,ReStart_4) FROM `Ticket Master_CR`;"
conn.Execute sqlstr
conn.Close
End Sub
\\\Unquote\\\
Whenever while executing the query, receiving below msg.