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 ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/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/
