DB in Read-Only

[esskaykay]

Again, I’m not sure if this is possible but…

We have a FrontEnd/BackEnd database. The BE has an autoexec routine that runs a few update queries nightly. All works fine as long as everyone closes the FE (as well as a few GIS apps that link to the BE). However, if someone forgets to close all, the BE’s autoexec will not run as it is deemed “Read-Only”. Is there a way to code the autoexec to close all connections or some other procedure which would allow the BE to update?

Thanks,
SKK

 

[Guus2005]

On the FE run a hidden form which monitors this setting in the table.

Like the sample database.

Share & Enjoy!

 

[esskaykay]

I'll play with this a bit.

Thanks,
SKK