Greetings, and a "How do you do?"

[dschomburg]

I just found this forum, and I was hoping someone could answer a question of mine.

I have a db which is not yet split, is located on a network drive and will be access by multiple users (without anysort of log on name). - Is there a way to open a form so that every user will see it at the same time. I'm trying to create a sort of "broadcast" message before I close the application and kick everyone off.

-Any help would help a heap.
Thanks,
Dave

 

[Fornatian]

The only way I think you could do that is to build yourself a custom table that only you have access to. When you want to send the 'kick off' message get each front end to check the value of the field value at intervals(say every five minutes) and say it is TRUE then display the message.

You would obviously only give yourself access to the form which sets the field value to TRUE.

Ian

 

[dschomburg]

Ok, that makes sense.
Thanks a heap. I will re-post with results.

Thanks again.

 

[dschomburg]

Awsome! I just had to set the "warning form" as the actual start up form and have the timer running then On_Timer it checks the value of a Global boolean var. If true then Msgbox("get the heck off") kinda thing.

Thanks for the suggestion!

 

[Fornatian]

It's good to talk.