Batch File Help - with Microsoft Access

Hi experts! I have a need to invoke a batch file via a scheduled task but need to close any connections to an Access back-end programatically...

There are quite a few users and some stay connected overnight.

I have used the Access tools in the past to kick folks off -- and I could use that here I guess -- just wondered if there were any alternatives to that.

Any suggestions welcome.

Thanks.
Eileen MurphyIndependent Application DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

pdebaetsCommented:
Our Inactive Shut Down utility might help - http://www.peterssoftware.com/isd.htm . It's free, and it will close end user front-ends after a specified period of inactivity. I like to set it to shut applications down after 3 hours of inactivity, then schedule night-time batch activity for around 3am, just in case someone works until midnight and leaves their computer on.
0
Bill RossProgrammerCommented:
Hi,

I use a manual shut down routine from the server.  I can check a ShutDownYN field in a maintenance table and bump all users off when needed.

In the front end I open a hidden form bound to the maintenance table.  In the OnTimer event of this form I requery the maintenance table every 10 seconds or so.

If the ShutDownYN field is true I show the form and a message to shut down.  I force a shut down using Quit in 1 minute - again using the form timer event.

Regards,

Bill
0
Eileen MurphyIndependent Application DeveloperAuthor Commented:
Hey Bill - that's the routine I've used in the past as well -- the only thing about that is, the Timer event makes some of the user's forms jump around. Have you experienced that? I will use that routine again - I just wondered if there was another alternative. I thank you for your input.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Bill RossProgrammerCommented:
I think if you use only one form and make it just for this purpose and open it hidden until you need it the users will not have an issue with jumping around.  It will never get the focus until you choose to fire it.

Regards,

Bill
0
Bill RossProgrammerCommented:
Additionally, I also write the user ID and datetime of login and log out to a usermaintenance table when the hidden form opens and closes (before the DB closes) so I know who is on or off at any time.

USERID + DateTimeOn + DateTimeOff are the fields in the UserMaintenance table.

Bill
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Eileen MurphyIndependent Application DeveloperAuthor Commented:
As always -- Thank you both so much.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.