Always asked to "Save Changes"?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I'm running Access 2007 database with Forms/Queries/Tables etc. I'm
always asked to "save changes to the following objects..." whenever I'd open
the database. I dont even have to edit a single cell or make any changes at
all and still get prompted to "Save changes". This does not happen in Access
2003 with this same database. Are there any suggestions on how to suppress
this dialog?

I can literally just open the database and click the X close button and
it'll ask for changes to be saved?
 
In your application's main form, add an On Close event. Inside that event, add the following code.

Application.Quit acQuitSaveNone

When this main form is closed, the application.quit function will kick in and you will no longer be prompted to save the changes upon exit.

Thanks,

Brian Jasmer
 
Back
Top