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

security

ResolvedVersion 2003

Fiona has attended:
Access Intermediate course
Access Advanced course

Security

how to set passwords

RE: security

Dear Fiona

Thank you for attending Access Advanced course!! I hope you enjoyed the course and benefited from it.

Please refer to the following link which provides you various security features that you have set in MS Access.

If you want to set general password to open the database then the database has to be opened in Exclusive mode. Similarly if you want to remove a password from a password protected database then again it has to be opened in Exclusive mode! This link provides you the step by step instruction.


http://www.databasedev.co.uk/database_password.html


If you are looking more from a user level security angle then please use the following link that will provide you step by step instructions (once you have understood the step 1 then press 2, 3, 4, etc...

http://databases.about.com/od/tutorials/ss/usersecurity.htm

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Mon 13 Apr 2009: Automatically marked as resolved.

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

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.14 secs.