If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Open mode
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 |
#2
|
|||
|
|||
Open mode
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 |
#3
|
|||
|
|||
Open mode
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 |
#4
|
|||
|
|||
Open mode
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 |
Thread Tools | |
Display Modes | |
|
|