98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Passowrd
Passowrd
Resolved · 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...
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Hiding rows and columnsTo 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 |