Access protection

The UK's most regular instructor-led training courses.
Training information: access vba · Access training · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2003

Access protection

Kevin has attended:
Access Intermediate course

by - delegate Kevin [4 posts] (2008 Jun 4 Wed, 09:09) Reply

Can you protect a table in Access from certain users, so they can't change the data?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 13 Tue	Bloomsbury	7	book now	£188	£215
2003	2009 Jan 16 Fri	Bayswater	5	book now	£198	£215
2003	2009 Jan 22 Thu	Bloomsbury	5	book now	£198	£215
2007	2009 Jan 27 Tue	Bloomsbury	4	book now	£224	£224
2003	2009 Feb 3 Tue	Southwark	7	book now	£188	£215
2003	2009 Feb 10 Tue	Bloomsbury	8	book now	£182	£207
Full Schedule: See all 58 Access Intermediate course dates. Bookings currently available until 23rd March 2010.

RE: Access protection

by - trainer Carlos gold contributer [496 posts] (2008 Jun 4 Wed, 10:50) Reply

Hi Kevin

The way to protect a table from having the data changed by certain users is to set up user level security, so that all users need a password to access the database

Then you can set which objects the users can access and whether they can make changes.

Alternatively you can hide all the tables and have the users access them by clicking buttons on forms.

These buttons could run Macros that open the table as Read Only

Hope this helps

Carlos

· Why go on a Microsoft Access Training Course?
· Access Database Optimization: First Normal Form
· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· How Reorganising Your Data Can Take Your Business to the Next Level
· Microsoft Access Beginners' Training: Getting to Grips with Databases

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

Access tip:

Calculating The Difference Between Dates

If you wish to calculate the time between two date fields, this can be done in a number of ways:

1. As a calculated field in a query
2. As a calculated control in a form or report
3. As a calculation in a VBA procedure.

The basic syntax to get the number of days between two dates is:

=[One Date Field] - [Another Date Field]

You can also use one of the following functions:

=Month([One Date Field] - [Another Date Field])
which calculates the number of months between the two fields

=Year([One Date Field] - [Another Date Field])
which calculates the number of years between the two fields.

Another function is the DateDiff() function.

It uses an argument to determine how the time interval is measured. For example:

=DateDiff("q",[One Date Field] - [Another Date Field])
returns the number of quarters between the two fields.

Other intervals that can be used in this expression are as follows:
"yyyy" - Years
"m" - Months
"d" - Days
"w" - Weekdays
"ww" - Weeks
"h" - Hours
"n" - Minutes
"s" - Seconds