Can't create new forms

20 Oct 2005 4:28 PM

taborp

I have a secured database. When I login to the database (I'm the
owner/administrator) I can create new labels and reports. When other users
login and try to create new labels using the label wizard, they get the
message that they do not have exclusive access and their changes won't be
saved. They can open previously made labels and reports (that I have made)
and can make new tables and queries, they just cannot make new
reports/labels. I have checked permissions and believe I have granted
permissions to the items they need, and they have full access to the folder
containing the database and ldb. The only problems is with reports...queries
and tables all work as they should. Any ideas?

20 Oct 2005 4:41 PM

taborp

Ok - I found the first answer...I had to check the "open exclusive" box in
security permissions on the database item for all users. Now, however, only
one person can edit a report at a time, which is fine, but how do I find out
who is currently using the database, so that when users call me to say they
don't have exclusive rights, I can find out who has it open?

Show quoteHide quote

"taborp" wrote:

> I have a secured database. When I login to the database (I'm the
> owner/administrator) I can create new labels and reports. When other users
> login and try to create new labels using the label wizard, they get the
> message that they do not have exclusive access and their changes won't be
> saved. They can open previously made labels and reports (that I have made)
> and can make new tables and queries, they just cannot make new
> reports/labels. I have checked permissions and believe I have granted
> permissions to the items they need, and they have full access to the folder
> containing the database and ldb. The only problems is with reports...queries
> and tables all work as they should. Any ideas?

20 Oct 2005 4:44 PM

Lynn Trapp

> Ok - I found the first answer...I had to check the "open exclusive" box in
> security permissions on the database item for all users. Now, however,
> only
> one person can edit a report at a time, which is fine, but how do I find
> out
> who is currently using the database, so that when users call me to say
> they
> don't have exclusive rights, I can find out who has it open?

Typically, you want to make all changes to objects such as forms and
reports, in a development copy of the front end (you do have the database
split, don't you?). Then you distribute those changes to the users when
they are finished and tested.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html