Access is forcing me to "save as" when canceling the design of a new object (form, query, report...)

  • Thread starter Thread starter Jason M Canady
  • Start date Start date
J

Jason M Canady

Does any one have an idea why access would be forcing me to save an object?
If I create a new Object and then try and close it (without saving) access
automatically brings up the Save As dialog and I must save it and then
delete it from the data base later. Also, it seems as though most of my
warnings about deletions have also gone away.

I read of a similar instance in here and am wondering if I should import all
of my objects into a new db? Any ideas would be appreciated.

Jason
 
Jason M Canady said:
Does any one have an idea why access would be forcing me to save an
object? If I create a new Object and then try and close it (without
saving) access automatically brings up the Save As dialog and I must
save it and then delete it from the data base later. Also, it seems
as though most of my warnings about deletions have also gone away.

I read of a similar instance in here and am wondering if I should
import all of my objects into a new db? Any ideas would be
appreciated.
Click to expand...

It sounds to me like somewhere the code statement

DoCmd.SetWarnings False

has been issued, without a corresponding

DoCmd.SetWarnings True

to re-enable the warnings.
 
Dirk,

Thanks a bunch. That was it! I searched through my code and found where I
had silenced the warnings to facilitate a make table query that runs fairly
ofter and then had never set them back on!

I love it when it's easy. I wonly wish I could find the easy ones myself!!!

Thanks again, Jason
 
Back
Top