Jump to content

How to Force users to disconnect while FM Script runs


 Share

This topic is 4406 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a FM Server 11 (Adv on Win) installation where I need to update one table via a server-side script at 2am every morning. Although most users will be logged off at that time, there is always the possibility that someone will be connected.

Is there any feature in FM Server that allows me to force a disconnect of all users of a particular database while a server-script runs?

I thought about closing and reopening the database and then having each client check for some value in a table (i.e. the last import date) before they are allowed to connect, but... thought there might be a more elegant built-in feature for doing this since it seems commonplace.

Thanks much in advance.

John Christensen

[email protected]

Link to comment
Share on other sites

Not sure why you would be worried about somebody still being logged in... you can trap for locked records and work around it me thinks.

But if you want to kick the users off, use a script sequence schedule. Use a batch file as the OS script that uses the fmsadmin command line to disconnect all clients. Make sure the batch file or VBscripts exits with a non-zero result if that command produces an error. That will prevent your FM script set up in the script sequence to run.

Link to comment
Share on other sites

This topic is 4406 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.