Difference between Parameter Query and Find Record

[Shazza]

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?

Thanks

 

[dhookom]

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]

 

[Shazza]

Thanks. I hadn't thought of that.