Report Design Permission

[Susan]

In Access 2000 we have set group permissions for 8 users
based on what they need to edit or enter data. For one
of these users, I want to give permission to edit the
design of a report and the query it is based on.

I have gone in and given that USER administrator
permissions to only that one report and query. She can
make changes to the query and save them fine, but when
she goes into design view of the report, she gets the
error message "You do not have exclusive access to the
database at this time. If you proceed to make changes,
you may not be able to save them later." and that is
true, she can not save them. There is absolutely nobody
else in the database at this time.

Can anybody tell me what we are doing wrong?
Thanks!
Susan

 

[Joan Wild]

In order to make design changes you need to open the mdb exclusively - that
doesn't mean open it and you happen to be the only one. It means File,
Open, locate the mdb and choose Open Exclusively in the FO dialog.
Alternatively you can use the /excl switch in a desktop shortcut when you
open the database.

Some alternatives:

Split the database and give each user a copy of the frontend (which you
should do anyway). That way the one user can open exclusively, however any
change they make to the report won't be available to others.

Give this user a separate database, where they can create queries/reports to
their hearts content.