Cannot create new forms, reports, or macros

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

Guest

I have a shared database on our LAN and have user rights setup to allow only
two persons to modify existing objects in the database. However, anyone can
create new objects. The problem is however, that people can only create new
tables and queries but not forms, reports, or macros. Why is this?

I also keep receiving the message about not haveing "Exclusive rights" to
the database when the other user with the right to modify is in the database.
Why is this?

Thanks,
Greg
 
hi,
Access has a security section where passwords,permissions,
rights, users, user groups, ect can be created and
administered.
If things seem odd to you, you need to talk to whoever set
that up.
Tools>security>Pick from list
Regards
Frank
 
Frank,

Thanks for your input. Actually, I setup all of the user rights and
permissions within access. It appears that when one of the users with modify
rights is in the database, regardless of whether they have any object open
such as a table or query, or etc., Access promotes that user to having
exclusive rights instead of just shared access and therefore, no one else can
create a form, report, or macro.

Greg
 
It appears that when one of the users with modify
rights is in the database, regardless of whether they have any object open
such as a table or query, or etc., Access promotes that user to having
exclusive rights instead of just shared access and therefore, no one else can
create a form, report, or macro.
Click to expand...

That's correct, annoyingly enough. With A2000, there is just one "box"
for all code in the database, including all report and form code; if
anyone has the box open, Access won't let anyone else open it. This of
course makes shared development of a database all but impossible.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top