There is a feature in Access which allows one to open a database and by pass
all modules, all macros and the startup options. All one has to do is hold
down the shift key when opening the database. Is there a way to disable this
feature?

Create a database property named AllowBypassKey and set its value to False.

See http://www.mvps.org/access/general/gen0040.htm at "The Access Web" for
how to do this properly.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"JR_06062005" <(E-Mail Removed)> wrote in message
news:9859DA84-DBA7-4370-8601-(E-Mail Removed)...
> There is a feature in Access which allows one to open a database and by
> pass
> all modules, all macros and the startup options. All one has to do is
> hold
> down the shift key when opening the database. Is there a way to disable
> this
> feature?

I have tried this but always get a compile error on the first function,
saying not defined. I tried the work around in another post about error
handling on 3265 instead and I still get the same compile error?

"Douglas J. Steele" wrote:

> Create a database property named AllowBypassKey and set its value to False.
>
> See http://www.mvps.org/access/general/gen0040.htm at "The Access Web" for
> how to do this properly.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "JR_06062005" <(E-Mail Removed)> wrote in message
> news:9859DA84-DBA7-4370-8601-(E-Mail Removed)...
> > There is a feature in Access which allows one to open a database and by
> > pass
> > all modules, all macros and the startup options. All one has to do is
> > hold
> > down the shift key when opening the database. Is there a way to disable
> > this
> > feature?
>
>
>

Assuming you copied everything between Code Start and Code End and pasted it
into a new module (not a class module, nor a module associated with either a
form or report), what did you name the module? Modules cannot have the same
name as routines contained within them.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Shanin" <(E-Mail Removed)> wrote in message
news:5D74A9D6-CC3A-4F0B-8CC2-(E-Mail Removed)...
>I have tried this but always get a compile error on the first function,
> saying not defined. I tried the work around in another post about error
> handling on 3265 instead and I still get the same compile error?
>
> "Douglas J. Steele" wrote:
>
>> Create a database property named AllowBypassKey and set its value to
>> False.
>>
>> See http://www.mvps.org/access/general/gen0040.htm at "The Access Web"
>> for
>> how to do this properly.
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>> "JR_06062005" <(E-Mail Removed)> wrote in message
>> news:9859DA84-DBA7-4370-8601-(E-Mail Removed)...
>> > There is a feature in Access which allows one to open a database and by
>> > pass
>> > all modules, all macros and the startup options. All one has to do is
>> > hold
>> > down the shift key when opening the database. Is there a way to
>> > disable
>> > this
>> > feature?
>>
>>
>>

I figured out my own idioticy. I forgot to mark the reference for DAO 3.6.

"Douglas J. Steele" wrote:

> Assuming you copied everything between Code Start and Code End and pasted it
> into a new module (not a class module, nor a module associated with either a
> form or report), what did you name the module? Modules cannot have the same
> name as routines contained within them.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "Shanin" <(E-Mail Removed)> wrote in message
> news:5D74A9D6-CC3A-4F0B-8CC2-(E-Mail Removed)...
> >I have tried this but always get a compile error on the first function,
> > saying not defined. I tried the work around in another post about error
> > handling on 3265 instead and I still get the same compile error?
> >
> > "Douglas J. Steele" wrote:
> >
> >> Create a database property named AllowBypassKey and set its value to
> >> False.
> >>
> >> See http://www.mvps.org/access/general/gen0040.htm at "The Access Web"
> >> for
> >> how to do this properly.
> >>
> >> --
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no e-mails, please!)
> >>
> >>
> >> "JR_06062005" <(E-Mail Removed)> wrote in message
> >> news:9859DA84-DBA7-4370-8601-(E-Mail Removed)...
> >> > There is a feature in Access which allows one to open a database and by
> >> > pass
> >> > all modules, all macros and the startup options. All one has to do is
> >> > hold
> >> > down the shift key when opening the database. Is there a way to
> >> > disable
> >> > this
> >> > feature?
> >>
> >>
> >>
>
>
>