change design in multiuser environment

[Denny]

Hi all,

I just found out that you can't change the design on any of the forms,
reports, modules, etc if you are not a single user.
Access try to get an exclusive access to save the file. So I don't knw
whether there's another way to fix my problems.

I've created 2 user,
1 admin
1 data entry
data entry user can't change the design, they only can add/ delete the
data.
But at some point, the admin need to change some reports/ forms
without asking the other user to log out.

Is there a way to achieve this?
I've read the microsoft knowledge base and find no clue about this.

Thanks heaps.

Denny

 

[Joan Wild]

Hi Denny,

I just found out that you can't change the design on any of the forms,
reports, modules, etc if you are not a single user.

But at some point, the admin need to change some reports/ forms
without asking the other user to log out.

You should split your database into frontend/backend. The frontend contains
everything except the tables/relationships. The backend contains just the
tables/relationships. You give a copy of the frontend to each user, which
is linked to the tables in the backend.

You can then make the design changes in your copy of the frontend and once
finished, distribute it to the users.

Since you've secured your database, you shouldn't use the database splitter
wizard to split the database, or the backend will end up unsecured. Instead
use the steps outlined at
www.jmwild.com/SplitSecure.htm

You can automate the distribution of the new frontend. Have a look at
http://www.granite.ab.ca/access/autofe.htm