Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
access course - database protection

Forum home » Delegate support and help forum » Microsoft Access Training and help » access course - Database protection

access course - Database protection

ResolvedVersion Standard

Tim has attended:
Access Intermediate course
Access Advanced course

Database protection

In some protected databases I have seen that some macro or code has been applied to hide all or most of the menu options (the protecton can be removed via an function key and password). Are such tools readily available.

RE: Database protection

Look under TOOLS > STARTUP

Tick or untick the various options available.

IF you hide the database window, and want it back, press F11 when in the database.

If you lock youself out completely, hold shift when opening the database, and it will override all the macros.

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.



View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.