access course - Database protection

The UK's most regular instructor-led training courses.
Training information: access course · Courses in microsoft access · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Database protection

Tim has attended:
Access Intermediate course
Access Advanced course

by - delegate Tim [2 posts] (2007 Jun 13 Wed, 16:35) Reply

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.

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Database protection

by - trainer Richard platinum contributer [818 posts] (2007 Jun 13 Wed, 16:39) Reply

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.

· Quick Access Database Courses: A 10 Step Lesson in Encrypting and Decrypting an Access Database
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps
· Tips for designing databases in Microsoft Access
· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· How To Find Good Access Database Courses In London

Access tip:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips