ADMIN RIGHTS

[Guest]

I have ADMIN rights to a database. Whenever I do any developement in that
database, i.e. creating or modifying a report, I shut out everyone else from
entering the database. What settins could be causing this?

Thank you.

 

[Van T. Dinh]

You probably open the database in "Exclusive" mode so that you can save the
design changes. Hence, no one else can get in.

For this reason (and others), we normally split a multi-user database
application to Fornt-End and Back-End.The Back-End contains only the Tables
and resides
on a shared folder that all users can access. The Front-End contain all
other Access objects and each user should have a copy of the Front-End on
his/her desktop.

Check Access Help on splitting a database.