Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

Thread Tools Rate Thread Display Modes
Old 04-07-2000, 10:15 AM   #1
Registered User
Join Date: Feb 2000
Posts: 72
Thanks: 0
Thanked 0 Times in 0 Posts
Close Access97 Open Sessions and Then Close Database- new twist

Close Access97 Open Sessions and Then Close Database- new twist

I need to automatically close a Access97 database so that Compacting can be done from a maintenance program.

I cannot use the On Timer() Event to automatically close the database because the Users often close all database objects (like forms) and work directly with the tables (which have no On Timer() events); The On Timer() event only works when a form is open.

Is there perhaps a way to remotely kick Users out of a database and then close it? (i can manually do it, but i need a VB or VBA solution!)

I am open to any suggestions; my current solution is to issue a memo that tells all users to close the database at the end of the day - but this is not a real solution.

Thank you!


llyal is offline   Reply With Quote
Old 04-07-2000, 10:04 PM   #2
Registered User
Travis's Avatar
Join Date: Dec 1999
Location: Kingsburg, CA, USA
Posts: 1,332
Thanks: 0
Thanked 1 Time in 1 Post
Travis is on a distinguished road
Do this. add a hidden form to the Startup and place the timer event here to check to see if you want to bring the program down.

by opening it on the startup hidden Most users will never know its there. They will just think you have this wonderful control over the system.
Travis L Abrahamson

Travis is offline   Reply With Quote
Old 04-11-2000, 04:07 AM   #3
Senior Member
Join Date: Mar 2000
Location: Munich, Germany
Posts: 101
Thanks: 0
Thanked 0 Times in 0 Posts
Sure You need a timed form, as Travis said.

This hidden form could check whether You have set a certain field to true (like [Parameters].[close]) and then does Application.Close. Accessing this table in a multi-user-environment is easy, isn't it?

MHM is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

All times are GMT -8. The time now is 06:29 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World