[2005] Parameterized query is not working

[KShum]

Using the Data Adapter configuration wizard, I am trying to create a query like following parameterized query:

SELECT tbl.* from tbl
WHERE (ID = @param1). I have set the parameter prefix to '@'.

I am getting the following warning:

The wizard detected the following problems when configuring the adapter "OleDbDataAdapter1":
Details: Generate SELECT Statement
Error in WHERE clause near '@'.
Unable to parse query text.


When I try to use "OleDbDataAdapter1.SelectCommand.Parameters("@param1").value = ... "

I get the following error:

An OleDbParameter with ParameterName '@param1' is not contained by this OldDbParameter.Collection.

I am new to VB2005. How do I get a parameterized query to work? Your help is greatly appreciated.