I am converting a database from using a MSSQL back end to a MySQL backend (first time) and am having trouble getting the ADO connection for a recordset to work. For the Access front end to MSSQL backend I am using this code:
Dim rsItems As New ADODB.Recordset
Dim conn As New Connection
Set conn = New ADODB.Connection
SQL = "Select * From [Items Check] Where [Order Number]=" + Format$(Me![Order Number])
rsItems.Open SQL, conn, adOpenStatic, adLockOptimistic
If Not rsItems.EOF Then rsItems.MoveFirst
Do Until rsItems.EOF
The code above works fine in that configuration, but when running it against MySQL it fails.
The first error is line 2, invalid use of new keyword. Removing the word "new" gets a little further to line 5 where I get method or data member not found.
I have tried several variations but they all give errors and I am unable to fine a set of commands that replace these for MySQL.
Any pointers very much appreciated.