Databases can be really frustrating to work with when a user wants to create the perfect query for a project or report.After making tweaks and changes to a query, it can be difficult to remember exactly what changes pulled which results.It also means that users can copy a good query and use it as a starting point for similar queries with only a few tweaks to get different data.Ultimately saving a query is a matter of preference, but for those who are just beginning that is another unknown area.It is up to each individual to determine when a query should be saved, but if you are not sure whether or not to save a query, you should go ahead and save.It is easy to delete queries later; it’s much more difficult to replicate one from memory a couple months down the road.We recommend using Active Directory and trusted links as your best scenario.
Each query that is saved can include some details to help the user determine what needs to be adjusted, so that each query does not have to be written from scratch.
His passion for Access has led him to helping a wide range of businesses in helping them establish a secure, stable and efficient environment with SQL Server.
He's a frequent speaker at Access user groups nationwide and recently spoke at the Orange County SQL Saturday # 73.
As users experiment with different queries, it is likely that they will find that a few tweaks to an existing query will give better or more complete data.
It is not necessary to delete these queries and completely replace them because Access allows users to update existing queries with relative ease.