From: Gina on
I have Access DB 2003 that I splitted it to front end and back end. I will
put the back end in shared drive and the front end in users' hard drives (4
users including me). No one except me needs to make change to the front end.
Should I set the open mode of the back end to "Shared", the front end of
each user to "Shared" and my front end to "Executive"? Thank you. Gina
From: Jerry Whittle on
I don't think that there is an "Executive". I think that you mean Exclusive.
If you do that, it's possible that you may lock out the others when you are
in the database. Actually not likely though as each user has a FE.

If your goal is to not allow users to mess with the forms and reports,
convert the FEs to an MDE file first. This compiles most everything and locks
it down pretty well. Users can still mess with queries though.

If you do go the MDE route, make sure that you keep a safe copy of the
original MDB file so that you can make changes as needed. You probably want
it on a different system with a copy of the BE for development purposes. You
really don't want to be testing things like update and delete queries on
production data!
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Gina" wrote:

> I have Access DB 2003 that I splitted it to front end and back end. I will
> put the back end in shared drive and the front end in users' hard drives (4
> users including me). No one except me needs to make change to the front end.
> Should I set the open mode of the back end to "Shared", the front end of
> each user to "Shared" and my front end to "Executive"? Thank you. Gina
From: tighe on
gina,

As a side note, although i am sure there are work arounds, but having the FE
on Vista is problematic. I ended up putting the FE on a shared drive, which
also gives me access to the folder if a user's copy gets corrupted, I have
access to change it without their input.

"Gina" wrote:

> I have Access DB 2003 that I splitted it to front end and back end. I will
> put the back end in shared drive and the front end in users' hard drives (4
> users including me). No one except me needs to make change to the front end.
> Should I set the open mode of the back end to "Shared", the front end of
> each user to "Shared" and my front end to "Executive"? Thank you. Gina
From: Gina on
Thank you for your advise. Gina :)

"Jerry Whittle" wrote:

> I don't think that there is an "Executive". I think that you mean Exclusive.
> If you do that, it's possible that you may lock out the others when you are
> in the database. Actually not likely though as each user has a FE.
>
> If your goal is to not allow users to mess with the forms and reports,
> convert the FEs to an MDE file first. This compiles most everything and locks
> it down pretty well. Users can still mess with queries though.
>
> If you do go the MDE route, make sure that you keep a safe copy of the
> original MDB file so that you can make changes as needed. You probably want
> it on a different system with a copy of the BE for development purposes. You
> really don't want to be testing things like update and delete queries on
> production data!
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "Gina" wrote:
>
> > I have Access DB 2003 that I splitted it to front end and back end. I will
> > put the back end in shared drive and the front end in users' hard drives (4
> > users including me). No one except me needs to make change to the front end.
> > Should I set the open mode of the back end to "Shared", the front end of
> > each user to "Shared" and my front end to "Executive"? Thank you. Gina