Problem opening a recordset ***RESOLVED (somewhat) ***

[DerFarm]

[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

[DerFarm]

ok, this works, but don't ask me why

   SQL = "SELECT [" & CategoricalTBLName & "].* "
   SQL = SQL & " FROM [" & CategoricalTBLName & "];"
   
   Set CategoricalRST = New ADODB.Recordset
   CategoricalRST.CursorType = adOpenKeyset
   CategoricalRST.LockType = adLockOptimistic
   CategoricalRST.ActiveConnection = CN
   CategoricalRST.Open SQL