If the database is on your computer, you can do something like this:

Set db = GetObject("C:\MyDatabase.ACCDB")
db.Application.Quit

But that only works if it's on the same computer you're working on. Seldom helpful. The only two ways to close an application remotely is to either connect to their system using something like Remote Desktop OR have a timer form running on their system that checks a linked table for a value/command to close once every hour.

It's funny you ask this, because right now I'm working on a project to remotely update objects (tables, queries, forms, etc.) on databases across a network. It's working great and is about 95% complete. The only problem I'm having is with Modules. They're a pain. I'm getting ready to publish what I've completed so far with the caveat that Modules are still a work in progress. MOST updates are to forms, and that's what I've made sure is working well.

Adding the ability to remotely shut down a workstation would be handy. I'll add it to this project. Look for it in the next day or two. I'm calling it ObjectCopy because the purpose is to copy objects from a central shared folder down to workstations. They have to run an event timer form, but it can be made to stay in the background or only run on startup. In your case, you'd want to let it run continuously and check every hour.

Good afternoon Richard sorry for the late response work has been hectic the front end database would be on everyone's computer backend is on the server i would like each persons front end to shut down on their computers with a timer event if there is no activity in the database on their machine within 1 hour is this possible  without removing into their system?

It's easy to set up a timer event so that the system will shut down in an hour. Make a form that they can't close. Set the OnTimer event to the Quit command I gave you earlier. Set the TimerInterval to an hour. The hard part is the "if there is no activity" part. You could set a variable in the system somewhere that gets reset to zero every time they do something like click a button or add a record, but Access has no way of tracking activity. I would say pop up a form in their face every hour and say "the system will shut down in 30 seconds unless you click OK" and then OK will reset the clock and not shut down on them. Lots of ways to do this.

I hoped to have my ObjectCopy database ready to be posted a few weeks ago, but I keep finding little bugs in it - and it's only a side project at this point so I work on it when I can. Forced remote shutdown of the database is on my list of things to add.

Thats sound like that will work thank you i we give it a shot