access
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access

Access

resolvedResolved · Low Priority · Version 2003

replyReply Mon 28 Apr 2008, 15:48Delegate Tony said...

Tony has attended:
Access Introduction course

Access

How do you stop other users changing the database?

For upcoming training course dates see: Pricing & availability

replyReply Tue 6 May 2008, 15:15Trainer Pete said...

RE: Access

Hi Tony, Thank you for your post, welcome to the forum, in answer to your question, which is covered in our Access Advanced course;
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, Pete

 

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

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard