Open mode
in [Getting Started]
|
From: Gina on 17 Feb 2010 13:32 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 17 Feb 2010 14:22 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 18 Feb 2010 11:28 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 18 Feb 2010 17:16 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
|
Pages: 1 Prev: How do I prevent others from editing my Access 2007 database? Next: hours, minutes, seconds |