Make a Form Expire

[Ripper]

I need to make a database not open once a period of time passes. At that
time I would like to be able to have them enter in another code to make it
work again for another period of time.

Does anyone have a tip on how to achieve this?

 

[KARL DEWEY]

If you create a macro named Autoexec it will run upon opening the database.
In it you can put stuff to do it like open form to enter code. If wrong
code then another macro to Quit.

Autoexec macro is bypassed by holding down shift key when opening the
database.

 

[John W. Vinson]

I need to make a database not open once a period of time passes. At that
time I would like to be able to have them enter in another code to make it
work again for another period of time.

Does anyone have a tip on how to achieve this?

How skilled and how determined (and how ethical) are the people who'll be
trying to open it?

As a desktop database, it's very hard to make a bulletproof security "shell"
around the database; a sufficiently clever and determined customer will be
able to crack pretty much anything you can put into it. That said, you can
give the user a .mde file, blocking access to your source code (mostly, that
can be hacked), hide all the default menus and toolbars and the database
window, and put code in the startup form's Open event to check the password.
It's a good bit of work.

See Tony's FAQ on the subject:

http://www.granite.ab.ca/access/demo.htm

and look around on some of the other Access websites:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

Stephen Lebans' awesome site:
http://www.lebans.com