Novice
Windows 2K 
Access 2003
Hi All,
I have a database on a shared drive that multiple users have to update periodically. Problem is only one person can update at a time. And unforunatly the users sometimes forget they are in the database blocking anyone else from completeing their work. Does anyone know of any code that i can put in the background so that if a user is ideal for more then 5 minutes a pop up message will remind then to get out???
Thanks so much
Access Developer
Windows XP Access 2003
Have you split the db.
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Novice
Windows 2K Access 2003
I suppose i could split it and run an update off a master table but i thought the pop up would be a little more fun.
VIP
Windows 7 32bit Access 2010 32bit
Yes, there's popup/signoff code various places around the internet. Basically, you use the timer property of a hidden form. The hard part is that you have to be sending timer-reset messages to that form whenever the user does anything significant. How big is your database, how many forms, how many queries, how is it used, etc.
Sometimes Helpful
Windows XP Access 2003
Maybe it is obvious. But, what are you updating exactly?
Multiple users using the database from shared drive all at same time
Posting Permissions
Reply With Quote