How to Force User Disconnect?

[dreyerempire]

We don't run FMP server, just client applications. For security and fault tolerance the DB files and application are on different computers. Users connect to a work station that maintains a connection to the database files throughout the day. My problems begin when I am trying to do scripted backups. Copying the files while the DB is open is not a good idea it has the potential to corrupt data. I want to shut down the application gracefully, but if a user is still connected, then I must ask to have them disconnect. They don't have to reply (it gives them 30 seconds), but I do have to click ask to disconnect them. I need to have this scripted, and you can't script a mouse click.

I need to have the application shut down gracefully, then I will run a copy script to multiple locations, then reopen the database. I have everything figured out except how to get users disconnected automatically. (BTW, I have a few crazy people that work well into the night, so an idle timeout may not always work)

Thanks

 

[kertusa]

I notice its been awhile since you posted this. If you've found an answer on your own, would you mind posting the outline of the fix for other users?

In case you haven't got a solution, here's my thought:
Use Applescript and remote apple events, send 'Quit' to the application that is hosting the files, make your backups, then send 'Launch'.

Will that work? Seems to work for me, in very limited testing.