What syntax to use for Access DB (.accdb) SQL parameters

I’m trying to utilize parameters in my Access db query. I’m testing by using a very simple Select statement with the From clause coming from an input string parameter. So far I’ve tried the following:

"Select * From @RBQWeekTable"
This gives me an error stating there’s an incomplete query clause.

"Select * From ?"
When I run this the error simply states that there’s a syntax error in FROM clause.

Am I missing an escape character or something? Anyone know the syntax on how to pass in parameters to a .accdb file?

1 Like