Open mode

  • Thread starter Thread starter Gina
  • Start date Start date
G

Gina

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
 
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!
 
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.
 
Thank you for your advise. Gina :)

Jerry Whittle said:
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!
Click to expand...
 
Back
Top