disable users ability to click debug on error

[Zodiacal]

how can i disable the ability for the user to click on the debug button if
there is an error in my access application?

 

[Van T. Dinh]

1. Ditribute your Front-End in MDE format, or

2. Set up the icon for user to run the database in Run-
time mode, or

3. Set up error-trapping in your code so that the user
does't get the Dialog with the Debug button.

(1) is the most secure sine the code is no longer there.
Even if the user knows his/her way in Access, he/she can't
access it. Note: neither can you in an MDE so you need to
keep a copy of the mdb in a secure place in case you need
to modify the database.

HTH
Van T. Dinh
MVP (Access)

 

[Zodiacal]

how do i configure the icon to run in run-time mode?

 

[Van T. Dinh]

The Target of the icon should be something like:

"C:\Office2K\Office\MSACCESS.EXE"
"I:\MyAccess2K\db1.mdb" /runtime

(all on 1 line)

Make sure you set a Startup Form for the database.

 

[Zodiacal]

it says i can't use the /runtime option with out first installing the office
developer tools. what is that?

 

[Van T. Dinh]

MS Office has a few different versions. The 2 versions that have Access are
the Professional Edition and the Developer's Edition known as MOD for
Microsoft Office Developer's Edition. The Developer Tools are part of the
Developer's Edition. The MOD is about twice as expensive as the
Professional Edition.

In A97, you have the /runtime switch even for the Professional Edition.
This must have been changed with later Office versions which I wasn't aware
of since I have been using the MOD for A2K and AXP.

Try the /rt switch which used to mean the same thing (run-time mode).