This text can be used to create a runtime environment. Make sure to put the correct location of the msaccess.exe. The second location is the location of the mdb file you want to open.
"C:\Program Files\Microsoft Office\Office\MSAccess.exe" "C:\Program Files\Microsoft Office\Office\Samples\Solutions.mdb" /runtime The article is found here. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modcore/html/detskDevelopingAccessRuntimeApplications.asp TJ --- Toby Bierly <[EMAIL PROTECTED]> wrote: > 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! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com ------------------------ 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/
