Kill Active Connections Programmatically?

[Guest]

Is there a way to kill all active connections to an access database?

Thanks!

 

[Douglas J. Steele]

You mean from within an MDB, you want to kill all connections being made to
it from outside of it?

I don't believe it's possible.

 

[Alex Dybenko]

Hi,
what you can do - is to build a procedure in frontend - when you need to
disconnect users - you set a flag in some settings table in BE, proc read
this flag say every 5 min, once it true - if force frontend shutdown using
docmd.quit

 

[Guest]

Thanks Alex. I think I understand. I will add a routine in autoexec to
check a flag and then have each attached client issue a docmd.quit should the
shut down flag equal true. Wasnt thinking this way. Thanks again!

Ed