A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Open mode



 
 
Thread Tools Display Modes
  #1  
Old February 17th, 2010, 07:32 PM posted to microsoft.public.access.gettingstarted
Gina
external usenet poster
 
Posts: 198
Default 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  
Old February 17th, 2010, 08:22 PM posted to microsoft.public.access.gettingstarted
Jerry Whittle
external usenet poster
 
Posts: 4,732
Default 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  
Old February 18th, 2010, 05:28 PM posted to microsoft.public.access.gettingstarted
tighe
external usenet poster
 
Posts: 53
Default 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  
Old February 18th, 2010, 11:16 PM posted to microsoft.public.access.gettingstarted
Gina
external usenet poster
 
Posts: 198
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:49 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.