[2005] Parameterized query is not working

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.

Note: I am connecting to an Access Database.

Tried it in code, and it looks like I got it. This is what I used:

Me.daAltVendorSelectCommand1.CommandText = "Select * from tblaltvendorinfo WHERE (VendorInfoID = @param1)"
Me.daAltVendorSelectCommand1.Connection = Me.OleDbConnection1
Me.daAltVendorSelectCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("@param2", System.Data.OleDb.OleDbType.Integer, 3, "VendorInfoID"))

Me.daAltVendorSelectCommand1.Parameters("@param2").Value = iVID.ToString
DsAltVendor1.Clear()
Me.daAltVendorInfo.Fill(DsAltVendor1)

I am new to VB2005. If anyone has any suggestions of better ways to accomplish parameterized queries, please let me know. Thank you.