Does anyone have any thoughts on best practices when working with querydefs?
I have an app that uses dynamic form parameters in a query def at runtime.
I've always just used something like
Set qd = CurrentDb.QueryDefs("MyQuery")
This overwrites the previous querydef and this works fine.
I've seen other people do a check if the query def exists, and delete it. Then use
Set qd = CurrentDb.CreateQueryDef("MyQuery")
I know both work, but is there an advantage of one method over the other?
Thanks!