Pop Up Message

[Ukraine82]

Hey what up?

I have a shared folder for Database.
I would like to make a pop up that shows up only on Friday at 3:00 p.m.
My pop up will say "Please Close the Database it needs to be repaired."

I can boot them off the Database, even though it not something you want to do if they are working on it.

The reason why I want to do it this is because my database increases 6 megs every week. So I would like to compact and repair.

I made a form(pop up message). I'm not exactly sure what to put in On Timer Event. I tried using Timer Interval 60000, which is what I want but the pop up shows up every day at 3:00 p.m.

I just want my pop up to show up only on Friday at 3:00 p.m.

Thanks,
Michael

 

[___]

If you are using A2K or above you can compact and repair every time the db closes. Tools >> Options >> General Tab, check compact on close.

HTH

 

[Ukraine82]

Isn't that going to effect the database. I have 20 users working on a database per day. Closing it daily, that's about 80x or more compacting and repairing per day.

Each user gets on 4 to 5x per day or more.

Michael

 

[___]

It sounds like you need to split your db, front end and back end. Have the front end db on each users pc, front end db contains only queries, forms, reports, pages, macros and modules. The back end (normally on the Server) contains only the tables. Then all you need to do is link the tables to the back end on each front end. Tools >> Database Utilities >> Linked Table Manager.

HTH

 

[Ukraine82]

I'm think I'm going to use that your example.

I tried using the VBA code, but can't get it to work...
2 = is 2nd day of the week which is today(Monday).

Private Sub Form_Timer()

If Weekday(Date) = 2 And Time() >= #2:00:00 PM# Then
Me.Visible = True

End If
End Sub

Timer Interval was 50000

Michael

 

[Captain Chaos]

How about something radical.
We have a number of databases that people use and we regularly need to close them for upgrade, compaction etc
We have a database called Cerberus (the dog that guards the entrance to hades! you'll see the connection soon). This contains a list of database names and a yes/no box for each
When a database tries to open, it interogates Cerberus to see if it can open. If not a warning messages appears for a few seconds and it quits.
But this is the best part. For databases that are already open Their timer is set to 5 mins and it interogates Cerberus each time to see if it can continue. If not it Puts a message on the screen saying it will close in 5 mimutes time.
The next timer interrupt will close the database.
All users will be ejected within 5-10 mins. The glory of this is that you can still kick people out who have gone for a pub lunch and not logged out.
You should be able to lock this in to VBFriday and >3pm and make something of it.

 

[Ukraine82]

Is there a link to Cerberus Website. If so, let me know what it is. Sounds very interesting.

Michael