Can't create new forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
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?
Click to expand...

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
 
Back
Top