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

passowrd

ResolvedVersion 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:

Space marks

It is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.