ADO and Access DB

The best way to work with Access is to run the queries such as create statements on your MS Access using Queries. Its a lot easier using the graphic interface to create SQL statements for Access. Once that's done simply paste the SQL statement on your web application.

 

There is a budget for my website, so I did not buy the add on for SQL Server. I am trying to us MS ACCESS, but it is proving not to be too much fun. I created a DataSet for the db and tried to create a datatable. When I write my sql to add a parameter I get an error saying that "Error in WHERE clause near '@'.
Unable to parse query text.". I don't get this if I use my sql server express db. I am going down the wrong path trying to us Access and ADO?

Thanks

 

It took me about a day to find an article....

Use the character: ?
As the full parameters

so

select *
from your_table
where key_field = ?

When it parses out, it will replace the ?
with a parameter option for key_field