Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Automatically closing Access database
- Thread starter HebieBug
- Start date
jimmythegeek
Programmer
Application.Quit
Or, if you have assigned the database to an object variable such as db, you use
db.Close
Jim Lunde
compugeeks@hotmail.com
Custom Application Development
Or, if you have assigned the database to an object variable such as db, you use
db.Close
Jim Lunde
compugeeks@hotmail.com
Custom Application Development
collegejohn
Technical User
Hi HebieBug!!
I am not sure what you mean by "no user intervention".Jim is correct,If you mean that the user does not close the db and leave access, the only other way is on a time interval bases which is straight forward.the best way to leave access is to use a macro driven by a command button in a form.in the macro field you will find quit, it is always good to preceed this with save just in case.
Regards john
I am not sure what you mean by "no user intervention".Jim is correct,If you mean that the user does not close the db and leave access, the only other way is on a time interval bases which is straight forward.the best way to leave access is to use a macro driven by a command button in a form.in the macro field you will find quit, it is always good to preceed this with save just in case.
Regards john
- Thread starter
- #4
FANTASTIC..
Thanks for all your helpful information..
The way this Database works is that it runs from a scheduler every 30 minutes.. It only needs to be open for 5 minutes though. So Wanted it to run through it sequence and then close.. Everything is done without a user having to type user name password or run the appopiate form..
And thanks to your helpful information has now been finished and should be in a bussiness by Monday..
Thanks for all your helpful information..
The way this Database works is that it runs from a scheduler every 30 minutes.. It only needs to be open for 5 minutes though. So Wanted it to run through it sequence and then close.. Everything is done without a user having to type user name password or run the appopiate form..
And thanks to your helpful information has now been finished and should be in a bussiness by Monday..
- Status
Similar threads
- Locked
- Question