And how is this done? Thanks, Toby
----- Original Message ----- From: "Trent Johnsey" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, September 29, 2005 10:00 AM Subject: RE: [AccessDevelopers] Keeping users away from the tables! > Just a thought, but I think a simpler solution is to simply force MS Access to > run in runtime mode. The shortcut to the can be modified to force MS access to > run in runtime mode. For those users who want to have access to the data, then > don't put the runtime instructions in the shortcut. > TJ > > --- "Hoffman, Tobi K (DYS)" <[EMAIL PROTECTED]> wrote: > > > How far you go will depend on 1) how trustworthy your people are, and 2) > > how sophisticated they are, as far as Access goes. First of all, make > > sure to go to the Startup options, hide the database window and have a > > specific startup form. You may want to disable the Shift-Key option > > before you compile the mde, then re-enable it to keep from blocking > > yourself out before you close. (One way to go is to always copy your > > development file, make the Shift-Key change -- and others if needed -- > > and compile from there.) There are other steps beyond that, some of > > which need to be used with great care so you maintain your own access to > > the front-end, but these will keep most casual users out. > > > > Tobi > > > > -----Original Message----- > > From: [email protected] > > [mailto:[EMAIL PROTECTED] On Behalf Of Cathy Jupp > > Sent: Thursday, September 29, 2005 11:40 AM > > To: [email protected] > > Subject: RE: [AccessDevelopers] Keeping users away from the > > tables! > > > > > > I'm in the process of moving my users from Access 2000 to 2003 > > and have purchased full licences for them all, as opposed to using the > > Runtime facility as we always have in the past. This leaves me with the > > problem of how to stop the users opening tables and wreaking havoc > > following a fatal error. It was never a problem with Runtime, because > > as soon as an error occurred the whole application closed down. I've > > read on this list more than once that user-level security is best > > avoided, so I was wondering whether there was an easy way of preventing > > table access without using it. > > I thought that creating an MDE file would be just the ticket, > > but that only protects the code, and as I copy the front end to the > > users' machines every time it is run, they can fiddle with that as much > > as they like for all I care! > > Thanks in advance > > Cathy > > > > > > > > Please zip all files prior to uploading to Files section. > > > > > > > > > > SPONSORED LINKS > > Microsoft access developer > > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+developer&w1=Micro > > soft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+datab > > ase&w4=Microsoft+access+training&w5=Microsoft+access+training+course&w6= > > Microsoft+access+programming&c=6&s=193&.sig=d-CjBIrYOH9NCKHYFeGZJA> > > Microsoft access help > > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+help&w1=Microsoft+ > > access+developer&w2=Microsoft+access+help&w3=Microsoft+access+database&w > > 4=Microsoft+access+training&w5=Microsoft+access+training+course&w6=Micro > > soft+access+programming&c=6&s=193&.sig=crx-d4AAhdklv_VozGVAUw> > > Microsoft access database > > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database&w1=Micros > > oft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+databa > > se&w4=Microsoft+access+training&w5=Microsoft+access+training+course&w6=M > > icrosoft+access+programming&c=6&s=193&.sig=qg2hDuQNweByMCX0NU7cEA> > > Microsoft access training > > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+training&w1=Micros > > oft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+databa > > se&w4=Microsoft+access+training&w5=Microsoft+access+training+course&w6=M > > icrosoft+access+programming&c=6&s=193&.sig=bLZHqTqWUQny609X1OkmNA> > > Microsoft access training course > > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+training+course&w1 > > =Microsoft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access > > +database&w4=Microsoft+access+training&w5=Microsoft+access+training+cour > > se&w6=Microsoft+access+programming&c=6&s=193&.sig=d8GQXfQW3RZ64rOfzIMo8A > > > Microsoft access programming > > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+programming&w1=Mic > > rosoft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+dat > > abase&w4=Microsoft+access+training&w5=Microsoft+access+training+course&w > > 6=Microsoft+access+programming&c=6&s=193&.sig=iXDlL79-kkgjv6fLyFu3Sg> > > > > _____ > > > > YAHOO! GROUPS LINKS > > > > > > > > * Visit your group "AccessDevelopers > > <http://groups.yahoo.com/group/AccessDevelopers> " on the web. > > > > * To unsubscribe from this group, send an email to: > > [EMAIL PROTECTED] > > <mailto:[EMAIL PROTECTED] > > > > > > > * Your use of Yahoo! Groups is subject to the Yahoo! > > Terms of Service <http://docs.yahoo.com/info/terms/> . > > > > > > _____ > > > > > > > > > > > __________________________________ > Yahoo! Mail - PC Magazine Editors' Choice 2005 > http://mail.yahoo.com > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
