• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 150
  • Last Modified:

Access when close database a window appears to make a new database

I have an Access 2010 database which when closed opens up the Access window as though I want to create a new database.  Why would this be happening?
0
SteveL13
Asked:
SteveL13
1 Solution
 
PatHartmanCommented:
Your current code is closing your application, not Access.

I would suggest using

Application.Quit acQuitSaveAll

the SaveAll isn't technically necessary since your users shouldn't be modifying application objects but it does prevent accidents if you happen to have warnings set to Off.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Either that, or you have compact on close set in File, Access Options (at the bottom of the menu) and it's having some type of issue.

Jim.
0
 
Gustav BrockCIOCommented:
>  or you have compact on close set in File

- and, I guess, under Options, Current Database, a start Form specified. Remove this if you wish to compact the database preserving the filename.

/gustav
0
 
SteveL13Author Commented:
Application.Quit acQuitSaveAll did the job.

I still have compact on close set in File, Access Options enabled but it is no longer opening the new database window.

And I still have a start form enabled.

--Steve
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now