I
Ivan
Hello,
in the Access 2003 mdb I used thise code to open a (stored) select query
qrySomeName as a recordset:
Dim rst As ADODB.Recordset
Set rst = New ADODB.Recordset
rst.ActiveConnection = CurrentProject.Connection
rst.Source = "qrySomeName"
rst.LockType = adLockOptimistic
rst.CursorType = adOpenForwardOnly
rst.Open
After I moved to Access 2007 I am geting but the error with description:
"Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT',
or 'UPDATE'.
What is wrong with my code?
Ivan
in the Access 2003 mdb I used thise code to open a (stored) select query
qrySomeName as a recordset:
Dim rst As ADODB.Recordset
Set rst = New ADODB.Recordset
rst.ActiveConnection = CurrentProject.Connection
rst.Source = "qrySomeName"
rst.LockType = adLockOptimistic
rst.CursorType = adOpenForwardOnly
rst.Open
After I moved to Access 2007 I am geting but the error with description:
"Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT',
or 'UPDATE'.
What is wrong with my code?
Ivan