[code]

Dim CategoricalRST As New ADOdb.Recordset
Dim SQL As String

strTemp0 = List2Add
intTemp0 = 1

SQL = "SELECT [" & CategoricalTBLName & "].* "
SQL = SQL & " FROM [" & CategoricalTBLName & "];"

CategoricalRST.Open SQL, CN, , , adCmdTable
[code]


CN is an open connection, properly passed. I can retrieve the connection string. SQL comes out as "Select [Name].* FROM [Name];" and it works in an Access query.

I get RunTime error (some huge negative number)
with the explanation: "Syntax error in FROM Clause"

I get the same error when replacing sql with the categoricaltblname.



Any suggestions?

I get