Access rights

Resolved · High Priority · Version 2007

Mon 7 Feb 2011, 16:14 Delegate Chris said...

Chris has attended:
Access Introduction course
Access Intermediate course

Access rights

restricting ability to change data

Fri 11 Feb 2011, 10:06 Trainer Anthony said...

RE: access rights

Hi Chris, thanks for your query and apologies for the delay. The simplest method of restricting the ability of a user to change the data in your database is to make it read only. IT usually get involved when different users want different access rights, although you can code specific solutions to this:

http://bytes.com/topic/access/answers/907039-how-set-forms-subforms-allow-edits-property

It's very situational, but as you can see solutions range from the file property level to bespoke coding solutions!

Hope this helps,

Anthony

Thu 17 Feb 2011: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips