Passwords

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

Resolved · Medium Priority · Version 2007

Passwords

Kate has attended:
Access Introduction course
Access Intermediate course

by - delegate Kate [4 posts] (2008 Apr 23 Wed, 16:17) Reply

How do you add/remove or change a password on a database?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Jul 8 Tue	Southwark	4	book now	£207	£215
2003/XP	2008 Jul 15 Tue	Bayswater	6	book now	£195	£205
2003/XP	2008 Jul 18 Fri	Bloomsbury	5	book now	£198	£215
2007	2008 Jul 24 Thu	Bloomsbury	4	book now	£224	£224
2003/XP	2008 Jul 29 Tue	Bloomsbury	5	book now	£198	£215
2003/XP	2008 Jul 30 Wed	Tooting	0	FULL
Full Schedule: See all 77 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Passwords

by - trainer Pete platinum contributer [600 posts] (2008 May 7 Wed, 15:37) Reply

Hi Kate,
Thank you for your post, welcome to the forum, in answer to your question, when you set/remove or change a password on a database the database must be in Exclusive user mode, in order to set this you should open Access on its own, Click Open Database and navigate to the folder where your database is kept, select the database icon (single click) and then in the Open File dialog box look for the little drop down arrow on the Open button. Choose Open Exclusive.
When the database has opened, from the Database window choose the menu option Tool>Security and Set your database password, if you already have a password set you must follow these steps again to remove it. To change the database password, first remove it then set a new password. I hope that has been of help to you, best regards Pete

· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· Microsoft Access Training Unleashes the Power of the Pivot Table
· Material covered on a Microsoft Access Course

Please browse our web site to find out more about
'ms access+course' and other Microsoft training courses.

Access tip:

Combo box for finding records

You can use a combo box in a form to look up a record. If you place the comb box in the Form header, by then selcting they a field type from the drop down loist, you will see the record for it

View all Access hints and tips