I am accessing an access database via a vb script using ADO.
I was wondering what was better
1. A predefined query in Access and then pass the parameters through the command object?
2. Return the entire table and then use rst.find?
I would create a dynamic sql statement that filters the records.
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.