Opening a table

[coughnut]

Hi, I am trying to open a table that has been named by the user. The name of the table is in a string called tableName.
When I run this part of my code I get an error saying that the table does not exist. But I see that the table is there, but why can't I open it. Thank you.

here is my code:

Set conDatabase = CurrentProject.Connection
strSQL2 = "SELECT * FROM tableName"
rs2.Open strSQL2, conDatabase, adOpenDynamic, adLockOptimistic

 

[RoyVidar]

Try concatenating the value into the string

[tt]strSQL2 = "SELECT * FROM " & tableName
' or
strSQL2 = "SELECT * FROM [" & tableName & "]"[/tt]

one will often see string variables prefixed with str, to avoid ambiguous names... (strTableName?)

Roy-Vidar