Date Limiting

[Tom]

How could I limit a MDB table by date? I want it to be
available to open for a week.

 

[Stephane]

Hi Tom,

Probably on the first form that you make your access start, you can
intercept by using the <<on Open>> or the <<on Load>> and check for the
date. If the <<date>> matches the out of time period then make the DB close
by using <<DoCmd.Quit acQuitSaveNone>>. This solution is not full proof
because a user can open the db by clicking the Access db icon and by holding
down the <<Shift>> button. But it<s worth a try.

Stephane

 

[Myles]

-----Original Message-----
How could I limit a MDB table by date? I want it to be
available to open for a week.
.
I use a third party software licensing component - there

are many of them, I use one produced by www.energy-
programming.com