exclusive rights database
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 » Exclusive Rights of Database

Exclusive Rights of Database

resolvedResolved · High Priority · Version 2003

replyReply Tue 18 Oct 2011, 09:33Delegate Ekpo said...

Ekpo has attended:
Access Intermediate course
Access Advanced course

Exclusive Rights of Database

I am trying to make a copy of a database to add some more fields to various forms to adapt it for another department since most of the tables will still be required. The only problem is i keep getting an error message saying 'i do not have exclusive rights and any changed will not be saved'. I have gone to tools -> options -> Advanced tab and changed the default open mode from shared to exclusive but still coming up with this same error message. Any tips or suggestions?

Many thanks,

Ekpo

For upcoming training course dates see: Pricing & availability

replyReply Wed 19 Oct 2011, 10:48Trainer Simon said...

RE: Exclusive Rights of Database

Hi Ekpo,

Thank you for your question.

The only thing I can suggest is to try and open the database from within the blank access window, locate and click once on the database to select it and then click on the drop down arrow next to the Open button and choose Open in Exclusive mode.

I will do some research and see if I can find anything.

I hope this helps.

Regards

Simon

 

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

Access tip:

Design View in Relationship window

Your in the Relationship window and changes are required to be made to a Table's design.

Rather than exiting the Relationship window, if you perform a right-mouse click on the table, it opens that table up in Design view

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