MyRecordset.Open Question

[jasonbarnes]

What is the proper syntax to reference a table in your database? Currently I'm using

Set MyRecordSet = New ADODB.Recordset
MyRecordSet.Open "TestData", CurrentProject.Connection



This errors out saying invalid SQL statement. The example in the book I'm using obviously doesn't use one and I would rather not.

[RuralGuy]

Did you intend to mark this as Solved?

[jasonbarnes]

Yeah. Had my table name wrong.

[RuralGuy]

Thanks for the update.