I'm perplexed, and would like to understand what the issue is. Sample code I've found shows that you can use OpenRecordSet to open a table just by naming the table. But when I try it, I get an error message. It will work, however, if turn it into a query. Why?
Code:
Dim oRS As DAO.Recordset
Dim recordings_table As String
recordings_table = "[Recordings]" ' name of the table
Set oRS = CurrentDb.OpenRecordset(recordings_table) ' Throws an error message: "cannot find the input table or query '[Recordings]'.
Set oRS = CurrentDb.OpenRecordset("SELECT * FROM " & recordings_table) ' opens without an error