save on exit

[Mcgrco]

Any time i opena table or query it asks me to save it on exit. This is really anoying as sometimes you want to use a temp query. Does anyone know how I can change this

 

[IMO]

Go to Tools >> Options >> Edit/Find and uncheck record changes, Document Deletions and Action queries

IMO

 

[Mcgrco]

Thanks I just worked it out . It was a simple case of not setting the warnings on.
Dooooh

 

[Pat Hartman]

Setting warnings off is VERY dangerous if you are modifying objects. If you simply close some object that you have spent an hour modifying without saving, you will NOT be prompted. All of your changes will be lost.

 

[Vassago]

Basically, if you are setting the Set Warnings Off, make sure you set them back On immediately after the tables are closed that you are modifying, or you will hvae the problems Pat is talking about. WHen you set warnings off, you are actually setting them off for Access period, even when working on forms in design view, etc.