Posts Tagged ‘mdb’

Using parameters for Ms Access query in VS query builder

Thursday, July 31st, 2008

It is difficult to use a parameterized query in VS to get data from a mdb database. You usually have to use ? instead of the parameters, but if you want to use the parameter more than once (like in an iif function or something like that), then you should probably need to use the name of the parameter.

To make a long story short, just use [@name]. Notice both [] and @ signs.