passowrd

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

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

Passowrd

resolvedResolved · Medium Priority · Version 2007

Paul has attended:
Access Introduction course
Access Introduction course

Passowrd

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

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

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

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

RE: Passowrd

Cress,

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

Paul


 

Access tip:

Hiding rows and columns

To hide a column or row in Access, you need to minimise the column or row. This can be done by placing your mouse on the right edge of a column, wait for the mouse to change to a double aroow and then drag to minimise the column

View all Access hints and tips


Server loaded in 0.08 secs.