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

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-07-2000, 10:15 AM   #1
llyal
Registered User
 
Join Date: Feb 2000
Posts: 72
Thanks: 0
Thanked 0 Times in 0 Posts
llyal
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


llyal is offline   Reply With Quote
Old 04-07-2000, 10:04 PM   #2
Travis
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
MHM
Senior Member
 
Join Date: Mar 2000
Location: Munich, Germany
Posts: 101
Thanks: 0
Thanked 0 Times in 0 Posts
MHM
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
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 10:11 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


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