passowrd
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Passowrd

Passowrd

resolvedResolved · Medium Priority · Version 2007

replyReply Mon 23 Feb 2009, 16:44Delegate Paul said...

Paul has attended:
Access Introduction course
Access Introduction course

Passowrd

How can password access be applied to a MS Access Database?

For upcoming training course dates see: Pricing & availability

replyReply Wed 25 Feb 2009, 10:48Trainer Cress said...

RE: Passowrd

Hello Paul
Thank you for your question

Open the database. Go to tools, security, set database password.


If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

replyReply Thu 26 Feb 2009, 14:28Delegate Paul said...

RE: Passowrd

Cress,

Thanks. When carrying out the above, I get an error message: "You must have the Database open for exclusive use to set or remove the password", with an explanation following on how to do this ("to open the database exclusively, close it, then reopen by clicking on the MS Office Button and using the Open Command. in the Open dialog box, click the arrow next to the Open Button, then select Open Exclusive").

However, there doesn't appear to be an "Open Dialogue" box shown when the instructions are followed. Are you able to advise on this, or is it a local IT issue?

Thanks, Paul

replyReply Sat 28 Feb 2009, 15:56Trainer Cress said...

RE: Passowrd

Hello Paul

Are you attempting to open it from windows explorer? Try opening the access database from within access itself by closing the database, clicking File, Open and locating the file. The arrow should be next to the open button. I have tried it on mine and it does work and I believe it should work on yours too, so i have attached a screen shot so you can see where I mean. Please can you check and see if this is what you were doing or if it still doesnt work?

thanks
cress

Attached files...

Open Exclusive.bmp

replyReply Mon 2 Mar 2009, 11:03Delegate Paul said...

RE: Passowrd

Cress,

Thanks very much for your help, which I have followed, and it is now working fine.

Paul

 

Please browse our web site to find out more about
microsoft database training and other Microsoft training courses.

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


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard