Break Into Code

[Guest]

I have an Access database that extracts information from a SQL database
through stored procedures and runs a report. I would like giving the end
users the option to cancel the extraction process. I have tried putting a
"CANCEL" on the form where they select the criteria for the report, but since
the form does not have the focus while the code is running that did not work.
They can press ctl-break to stop the process but then they can get access to
the code. Any ideas of how I can give them the option to cancel the process
without allowing them to get access to my code?

Thanks

 

[Susie DBA [MSFT]]

I believe that you can compile to MDE.. and then have peolpe hit CTRL
+BREAK and it will only give an option to END it won't give an option
for debug

but.. if you're really using stored procedures.. you _ARE_ usnig
Access Data Projects right?

I mean-- Microsoft reccomends that you use ADP specifically for
reporting

 

[dbahooker]

if you compiled into an MDE.. then you wouldn't have to give end users
access to your source code

hitting CTRL+BREAK would still give them the ability to END I
believe.. but not debug

-Aaron

 

[IRS Intern]

I do believe that you can use a MDE format; and then your end users
could still END but they wouldn't be able to get into your source code

hope that helps-

 

[Guest]

Thanks for your help. I ended adding AllowBreakIntoCode = false to my start
up and add a msgbox to prevent the end user from running a report without all
the information filled in on the form filter.