Why does Access 2007 save query changes w/o prompting?
In some of my databases, when I edit a query in design mode Access saves the changes I made without prompting me if I wish to save changes. Additionally in those databases, it will force me to name and save a new query before I can close the query or the database (clicking cancel will take me back to the query pane w/o closing it). I need to be able to run quick variants of existing queries or wholly new queries, and look at the resulting data just that one time… without having to clean up a mess of temporary queries saved to my database, and without breaking my existing queries because changes were saved without warning. This only seems to happen on new databases that I create. When opening old databases (created with Access 2000) it does not do this. Note that my new databases are being saved Access 2000 file format to that they are compatible with coworkers who have not upgraded to the latest access.
Related Questions
- The UADriver always changes requested query timeout value to zero therefore not allowing applications to change the timeout value. Why is this?
- What changes will be needed to switch DB/Text WebPublisher PRO query screens and forms to CS/WebPublisher PRO?
- What changes are needed for an IA-32 based platform to run a 64-bit O/S and 64-bit applications?
