Hi,

Is there a specific connection that needs to be used when trying to open a recordset with an sql statement?  Here's the code I'm using to create the connection:

Set adoConnect = New ADODB.Connection
strCnn = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=filestructure04.mdb"
adoConnect.Open strCnn
    
Set adoRecordset = New ADODB.Recordset
adoRecordset.CursorType = adOpenKeyset
adoRecordset.LockType = adLockOptimistic
adoRecordset.Open "SELECT * FROM struct04", adoConnect, , , adCmdTable

The error I get when running this code is:
"Syntax error in FROM clause", which points to the bolded line in the code shown above.  Can someone please advise on anything I need to include to make this work?

Thanks  

The connection that you used to open the database (like you have done)

Make sure "struct04" is a table.

Try:
' Removing the two lines prior to the open line
adoRecordset.Open "SELECT * FROM struct04", adoConnect, adOpenKeyset, adLockOptimistic
-OR-
' If you keep the prior two lines
adoRecordset.Open "SELECT * FROM struct04", adoConnect

quote:

---

sunflower wrote:
Hi,

Set adoConnect = New ADODB.Connection
strCnn = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=filestructure04.mdb"
adoConnect.Open strCnn
    
Set adoRecordset = New ADODB.Recordset
adoRecordset.CursorType = adOpenKeyset
adoRecordset.LockType = adLockOptimistic

use this statement

adoRecordset.Open "SELECT * FROM struct04", adoConnect, , , 1