Disable forms from being accessed for a period of time

[spudracer]

I'm in the process of creating a database in Access 2010 that has two front ends, basically. What I want to be able to do is lock out one of those front ends for a specific period of time every day.

Does anyone have an example they can share?

 

[MarkK]

What do you mean, "lock out?" Refuse to open? Open, but disallow edits?

You can check the time in code and take certain actions like, between 9am and 9:59:59am, this block would run . . .

If Hour(Time()) = 9 Then
   msgbox "It is between 9 and 10 am right now"
End If

Hope this helps,

 

[spudracer]

User logs in at 9:01 am. Database is locked between 9 am and 12 pm. User receives a message stating that the database is currently locked and then the database closes.