Thanks John! Our objective is to try to find a way to execute code even when the db is opened using the shift key. The reason for this is to prevent vba savvy intruders who know how to write code in an external db to modify startup properties in our db. It's all a matter security and good ol' audit.
Thanks in advance!
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Mike-
>
> Search help for the AllowBypassKey property. If you define and set that to
> False, the Shift key won't work. Be sure you make a copy of your database
> before you do this so you don't lock yourself out. What I do is run code to
> define the property and set it to True. I then make an accde file, then use
> a bit of code to open the accde and set the property to False. Then give
> the accde to users.
>
> John Viescas, Author
> Microsoft Access 2010 Inside Out
> Microsoft Access 2007 Inside Out
> Microsoft Access 2003 Inside Out
> Building Microsoft Access Applications
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mithomas48
> Sent: Friday, November 01, 2013 4:12 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Alternative to AutoExec
>
> Looking for a way to execute code even if someone uses the shift key by pass
> to open the database. Is there a way to do this?
>
> Thanks in advance!
> Mike
>
>
>
> ------------------------------------
>
> Yahoo Groups Links
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar