Shift Bypass

[box2003]

When I implement the Shift-bypass startup feature in an Access application
(instead of making a *.mde file), is there any way for a user to bypass the
protection of my Shift-bypass feature without first knowing the macro used
to implement it?

 

[Rick Brandt]

When I implement the Shift-bypass startup feature in an Access
application (instead of making a *.mde file), is there any way for a
user to bypass the protection of my Shift-bypass feature without
first knowing the macro used to implement it?

Yes they would have to know about enabling and disabling that feature, but
if the user has any experience with Access they likely do know that. If you
implement User Level Security you can run the disable bypass key code in a
manner that requires anyone running code to undo it to be an Administrator
on the database.

 

[box2003]

I guess I have answered my question, by using an import function from
another Access application and selecting the affected Access database of
question, I was able to expose all forms, queries, and everything else in
the application. The original author hard coded references to an *.mdb file
throughout the current application and it fails in functionality when I
change or make an *.mde file from the *.mdb file.

 

[TC]

By "references", do you mean that it references and external MDB once,
in Tools : References, then uses functions provided by that MDB?

If so, then all you probably need to do, is to MDE the referenced
database as well as the referencing one (and change the reference
accordingly). IOW, there are some rules as to whether an MDB can
reference an MDE & vice versa.

HTH,
TC