Run script only when there are no other users

[rbs]

Hi Everyone,

I have script running when a form closes, as follows:


Private Sub Form_Close()

DoCmd.RunMacro "UPDATE CUSTOMERS"

DoCmd.OpenForm "CUSTOMERS"

End Sub

I want it to only run the macro "UPDATE CUSTOMERS" if there is no one else using the database at the same time.

Thanks in advance,


Natalie