Database Locks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ilan - 29 Jul 2004 15:23 GMT

Hello,
i am having trouble with my secured database. i have
read only users, admins, and full data users. i would
like to have the full data users and admins to be able to
edit records while read onlys are in the file. Right
now, i get a message
saying:

"Microsoft Access can't save design changes or save to a
new database object because another user has the file
open. To save your design changes or save to a new
object, you must have exclusive access to the file"

This occurs when a read only user has the file open and
an admin user is trying to save.

What i would like to happen is have the read only users
be able to look at the data without interfering with the
users who are admins.

Any suggestions?

Thank you so much,
Ilan

Reply to this Message

Tony Toews - 29 Jul 2004 23:37 GMT

>i am having trouble with my secured database. i have
>read only users, admins, and full data users. i would
[quoted text clipped - 14 lines]
>be able to look at the data without interfering with the
>users who are admins.

You want to split the MDB into a front end containing the queries,
forms, reports, macros and modules with just the tables and
relationships. The FE is copied to each network users computer. The
FE MDB is linked to the tables in the back end MDB which resides on a
server. You make updates to the FE MDB and distribute them to the
users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. It also supports Terminal Server/Citrix quite nicely.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Reply to this Message