If I need to select some data from Access db I create SQL statement in VB. But I read recently in one book that it's bad idea. If you create parameter query in Access db and then call it from VB, it works faster. I coudn't find any sample how to do that. How to pass parameter? I'm not even sure that it's possible in Access. I know that this scenario is used in SQL Server with stored procedures. But how about VB and Access?
Any help would be appreciated.
Thank you
Vlad