Exclusive

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

Guest

With the Exclusive Setting, can you edit and design reports and forms while
setting the permissions for other users to edit a the database?

I have read up on the rights and I am a little confused. It sounds as if
once an administrator begins to design reports and forms on a shared
database, you will lock the other users out of the entire database?

If I set the permissions correctly, can I as the administrator design (and
save) the reports/forms while my coworker (in a user group w/permissions set
correctly) continue to input save data?

Any response would be greatly appreciated.
Katierb40
 
Hi.
With the Exclusive Setting, can you edit and design reports and forms while
setting the permissions for other users to edit a the database?
Yes.

It sounds as if
once an administrator begins to design reports and forms on a shared
database, you will lock the other users out of the entire database?
Click to expand...

Let's put another perspective on this. Would you allow your mechanic to
work under the hood while you were driving your car down the freeway at 60
MPH? No. Don't make database design changes while a user is "operating the
vehicle."
If I set the permissions correctly, can I as the administrator design (and
save) the reports/forms while my coworker (in a user group w/permissions set
correctly) continue to input save data?
Click to expand...

Only if one is using a version of Access before Access 2K, which allowed
this scenario and produced database corruptions galore -- which is why
Microsoft prevented this ability in Access 2K and all later versions.

It's best to split the database into a front end and back end, place the
back end (tables and relationships) on a shared network drive and place a
copy of the front end (forms, queries, reports, modules, et cetera) on each
user's workstation, with links to the tables in the back end. This setup
allows the developer to develop the database application independently from
the users.

For more information on split databases, please see the following Web page:

http://www.Access.QBuilt.com/html/gem_tips.html#SplitDB

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Back
Top