Acess

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

Resolved · Low Priority · Version 2003

Acess

Darren has attended:
Access Introduction course

by - delegate Darren [1 post] (2008 Apr 28 Mon, 15:48) Reply

How do you lock down the data from other users

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 4 Thu + 5 Fri	Southwark	0	FULL
2003	2008 Oct 20 Mon + 21 Tue	Southwark	6	book now	£450	£485
2003	2008 Nov 6 Thu + 7 Fri	Southwark	7	book now	£345	£399
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	7	book now	£345	£399
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 15 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Acess

by - trainer Pete platinum contributer [799 posts] (2008 May 6 Tue, 16:54) Reply

Hi Darren, Thank you for your post, welcome to the forum, in answer to your question, this subject is covered in our Access Advanced course; But to give you a little insight;
To set user rights you can use the Security Wizard which you will find by opening the Database window and at the Menu command Tools choose the option Security> User-Level Security Wizard.
Follow the steps to set user rights as required for your network.
Note: These operations should be carried out for the first time on a copy of your database, as incorrect operation could cause the database to become totally locked against all users.
I hope that has set you in the right direction, best regards Pete Emmerson; Microsoft Office Specialist Master Instructor

· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· Microsoft Access 2007: New Features
· Microsoft Access Training Opens Doors
· How Reorganising Your Data Can Take Your Business to the Next Level
· Access VBA Handling Errors and Debugging Code

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

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips