Unanswered: Syntax Error in "rs.open . . ." statement
I just started getting error messages from an Access module that was working fine. I believe it has something to do with my "References", but I can't figure out what is wrong.
My references are and always have been:
Visual Basic for Applications
Microsoft Access 10.0 Object Library
Microsoft ActiveX Data Objects 2.5 Library
Microsoft Excel 10.0 Object Library
Microsoft Office XP Web Components
Microsoft ADO Ext. 2.8 for DDL and Security
Microsoft DAO 3.6 Object Library
Microsoft Visual Basic for Applications Extensibility 5.3
My code looks like this:
Dim rs As ADODB.Recordset
Dim strTest As String
Set rs = New ADODB.Recordset
rs.ActiveConnection = CurrentProject.Connection
strTest = "qryRecords"
rs.Open "Select * from " & strTest
I keep getting the following error message at the rs.Open "Select . . . Statement:
Create a new module and copy and paste the code over. There are many things that start acting squirly after a Windows update. Recently, Microsoft has posted a flury of updates and many things that used to work just fine started acting up. In some of the more bizarre cases, I found it easiest to simply recreate the object.
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.