"Sabrina" <Sabr***@discussions.microsoft.com> wrote in message
news:D7ECE02C-C8C0-4858-9E5D-07D17F699682@microsoft.com...
>I have an Access2000 application with 3 linked databases (tables only). I
>am
> trying to lock the application down so users who have full MS Access
> installed cannot get to the data by going into the database window and
> opening any table(i.e. they should only be able to view data via forms),
> this
> is because the database contains settings for many other users and should
> be
> private.
>
> Each linked database has a password applied but the data is available in
> the
> main application as you have to provide the password when initially
> linking
>
> Setting an workgroup file does not work as you either give permission to
> read data or not at user level
>
> An MDE only locks down the code
>
> does any body have any thoughts on this
>
> regards

"Lynn Trapp" wrote:

> Sabrina,
> You should disable to Shift key bypass and hide the database window.
>
> http://www.mvps.org/access/general/gen0040.htm
>
> --
> Lynn Trapp
> MS Access MVP
> www.ltcomputerdesigns.com
> Access Security: www.ltcomputerdesigns.com/Security.htm
> Jeff Conrad's Access Junkie List:
> http://home.bendbroadband.com/conradsystems/accessjunkie.html
>
>
>
> "Sabrina" <Sabr***@discussions.microsoft.com> wrote in message
> news:D7ECE02C-C8C0-4858-9E5D-07D17F699682@microsoft.com...
> >I have an Access2000 application with 3 linked databases (tables only). I
> >am
> > trying to lock the application down so users who have full MS Access
> > installed cannot get to the data by going into the database window and
> > opening any table(i.e. they should only be able to view data via forms),
> > this
> > is because the database contains settings for many other users and should
> > be
> > private.
> >
> > Each linked database has a password applied but the data is available in
> > the
> > main application as you have to provide the password when initially
> > linking
> >
> > Setting an workgroup file does not work as you either give permission to
> > read data or not at user level
> >
> > An MDE only locks down the code
> >
> > does any body have any thoughts on this
> >
> > regards
>
>
>

"Sabrina" <Sabr***@discussions.microsoft.com> wrote in message
news:AC74DE9E-7E46-40D2-97F8-043B7A37D631@microsoft.com...
> Hi Lynn
>
> Thanks for this, the by pass key works perfectly but by pressing F11 it is
> still possible to raise the database windows, what do you mean by 'hide'
>
> Regards
>
> sabrina
>
> "Lynn Trapp" wrote:
>
>> Sabrina,
>> You should disable to Shift key bypass and hide the database window.
>>
>> http://www.mvps.org/access/general/gen0040.htm
>>
>> --
>> Lynn Trapp
>> MS Access MVP
>> www.ltcomputerdesigns.com
>> Access Security: www.ltcomputerdesigns.com/Security.htm
>> Jeff Conrad's Access Junkie List:
>> http://home.bendbroadband.com/conradsystems/accessjunkie.html
>>
>>
>>
>> "Sabrina" <Sabr***@discussions.microsoft.com> wrote in message
>> news:D7ECE02C-C8C0-4858-9E5D-07D17F699682@microsoft.com...
>> >I have an Access2000 application with 3 linked databases (tables only).
>> >I
>> >am
>> > trying to lock the application down so users who have full MS Access
>> > installed cannot get to the data by going into the database window and
>> > opening any table(i.e. they should only be able to view data via
>> > forms),
>> > this
>> > is because the database contains settings for many other users and
>> > should
>> > be
>> > private.
>> >
>> > Each linked database has a password applied but the data is available
>> > in
>> > the
>> > main application as you have to provide the password when initially
>> > linking
>> >
>> > Setting an workgroup file does not work as you either give permission
>> > to
>> > read data or not at user level
>> >
>> > An MDE only locks down the code
>> >
>> > does any body have any thoughts on this
>> >
>> > regards
>>
>>
>>

"Lynn Trapp" wrote:

> Sabrina,
> The code in the module should  prevent F11 from working. Tools > Startup
> allows you to choose to hide the database window.
>
> --
> Lynn Trapp
> MS Access MVP
> www.ltcomputerdesigns.com
> Access Security: www.ltcomputerdesigns.com/Security.htm
> Jeff Conrad's Access Junkie List:
> http://home.bendbroadband.com/conradsystems/accessjunkie.html
>
>
>
> "Sabrina" <Sabr***@discussions.microsoft.com> wrote in message
> news:AC74DE9E-7E46-40D2-97F8-043B7A37D631@microsoft.com...
> > Hi Lynn
> >
> > Thanks for this, the by pass key works perfectly but by pressing F11 it is
> > still possible to raise the database windows, what do you mean by 'hide'
> >
> > Regards
> >
> > sabrina
> >
> > "Lynn Trapp" wrote:
> >
> >> Sabrina,
> >> You should disable to Shift key bypass and hide the database window.
> >>
> >> http://www.mvps.org/access/general/gen0040.htm
> >>
> >> --
> >> Lynn Trapp
> >> MS Access MVP
> >> www.ltcomputerdesigns.com
> >> Access Security: www.ltcomputerdesigns.com/Security.htm
> >> Jeff Conrad's Access Junkie List:
> >> http://home.bendbroadband.com/conradsystems/accessjunkie.html
> >>
> >>
> >>
> >> "Sabrina" <Sabr***@discussions.microsoft.com> wrote in message
> >> news:D7ECE02C-C8C0-4858-9E5D-07D17F699682@microsoft.com...
> >> >I have an Access2000 application with 3 linked databases (tables only).
> >> >I
> >> >am
> >> > trying to lock the application down so users who have full MS Access
> >> > installed cannot get to the data by going into the database window and
> >> > opening any table(i.e. they should only be able to view data via
> >> > forms),
> >> > this
> >> > is because the database contains settings for many other users and
> >> > should
> >> > be
> >> > private.
> >> >
> >> > Each linked database has a password applied but the data is available
> >> > in
> >> > the
> >> > main application as you have to provide the password when initially
> >> > linking
> >> >
> >> > Setting an workgroup file does not work as you either give permission
> >> > to
> >> > read data or not at user level
> >> >
> >> > An MDE only locks down the code
> >> >
> >> > does any body have any thoughts on this
> >> >
> >> > regards
> >>
> >>
> >>
>
>
>

"Sabrina" <Sabr***@discussions.microsoft.com> wrote in message
news:B91D401D-FF96-40D3-B6C4-C99995576608@microsoft.com...
> Many thanks Lynn this works perfectly
>
> "Lynn Trapp" wrote:
>
>> Sabrina,
>> The code in the module should  prevent F11 from working. Tools > Startup
>> allows you to choose to hide the database window.
>>
>> --
>> Lynn Trapp
>> MS Access MVP
>> www.ltcomputerdesigns.com
>> Access Security: www.ltcomputerdesigns.com/Security.htm
>> Jeff Conrad's Access Junkie List:
>> http://home.bendbroadband.com/conradsystems/accessjunkie.html
>>
>>
>>
>> "Sabrina" <Sabr***@discussions.microsoft.com> wrote in message
>> news:AC74DE9E-7E46-40D2-97F8-043B7A37D631@microsoft.com...
>> > Hi Lynn
>> >
>> > Thanks for this, the by pass key works perfectly but by pressing F11 it
>> > is
>> > still possible to raise the database windows, what do you mean by
>> > 'hide'
>> >
>> > Regards
>> >
>> > sabrina
>> >
>> > "Lynn Trapp" wrote:
>> >
>> >> Sabrina,
>> >> You should disable to Shift key bypass and hide the database window.
>> >>
>> >> http://www.mvps.org/access/general/gen0040.htm
>> >>
>> >> --
>> >> Lynn Trapp
>> >> MS Access MVP
>> >> www.ltcomputerdesigns.com
>> >> Access Security: www.ltcomputerdesigns.com/Security.htm
>> >> Jeff Conrad's Access Junkie List:
>> >> http://home.bendbroadband.com/conradsystems/accessjunkie.html
>> >>
>> >>
>> >>
>> >> "Sabrina" <Sabr***@discussions.microsoft.com> wrote in message
>> >> news:D7ECE02C-C8C0-4858-9E5D-07D17F699682@microsoft.com...
>> >> >I have an Access2000 application with 3 linked databases (tables
>> >> >only).
>> >> >I
>> >> >am
>> >> > trying to lock the application down so users who have full MS Access
>> >> > installed cannot get to the data by going into the database window
>> >> > and
>> >> > opening any table(i.e. they should only be able to view data via
>> >> > forms),
>> >> > this
>> >> > is because the database contains settings for many other users and
>> >> > should
>> >> > be
>> >> > private.
>> >> >
>> >> > Each linked database has a password applied but the data is
>> >> > available
>> >> > in
>> >> > the
>> >> > main application as you have to provide the password when initially
>> >> > linking
>> >> >
>> >> > Setting an workgroup file does not work as you either give
>> >> > permission
>> >> > to
>> >> > read data or not at user level
>> >> >
>> >> > An MDE only locks down the code
>> >> >
>> >> > does any body have any thoughts on this
>> >> >
>> >> > regards
>> >>
>> >>
>> >>
>>
>>
>>

> I have an Access2000 application with 3 linked databases (tables
> only). I am trying to lock the application down so users who have
> full MS Access installed cannot get to the data by going into the
> database window and opening any table(i.e. they should only be able
> to view data via forms), this is because the database contains
> settings for many other users and should be private.
>
> Each linked database has a password applied but the data is available
> in the main application as you have to provide the password when
> initially linking
>
> Setting an workgroup file does not work as you either give permission
> to read data or not at user level
>
> An MDE only locks down the code
>
> does any body have any thoughts on this
>
> regards