我正在使用ADO Recorset访问MySQL表,但是ADO Recordset不返回记录。我在Visual Studio中使用VB.NET。我可以与数据库建立通信,建立连接,创建表,所有这些都通过connection对象(如下所示),但在通过Recordset返回信息时,会给出错误。As New ADODB.RecordsetDim aux As String
aux = "Provider = MSDASQL;Driver={MyS
Set myConnection = CurrentProject.Connection ' Crash here mySQL = mySQL & "UPDATE Amplifier " mySQL= mySQL & "SET Amplifier.lngCategory = 405, Amplifier.lngSubType = 3 " mySQL = mySQL & "WHERE (((Amplifie