Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old February 14th, 2004, 04:35 PM
Authorized User
 
Join Date: Nov 2003
Location: Hillsboro, Ohio, USA.
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to bjackman Send a message via MSN to bjackman
Default Sandbox Mode

In Access 2003 does anybody know how to programmatically or otherwise get rid of the nag screens for the sandboxmode, i have tried digitally signing the vba code and everything else i can think of. I'm using access developer tools to create an install package coupled with the access 2003 runtime files and i really don't want the user to have to click that they want to open the file everytime. Any input would be greatly appreciated.

Branden

Reply With Quote
  #2 (permalink)  
Old February 16th, 2004, 10:42 AM
Friend of Wrox
 
Join Date: Jul 2003
Location: Houston, Texas, USA.
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Branden,

I have had the same issues this past week. M$ publishes (at http://office.microsoft.com/assistan...HA011071331033) that you can modify the macro security settings through code by using the following:

Application.AutomationSecurity = msoAutomationSecurityLow

Ok, this was the answer to my problems, but then, when I compile, it highlights msoAutomationSecurityLow and tells me that the variable is not defined. Someone else suggested I change this to Application.AutomationSecurity = 1, which I did and although the code was fine, I'm having a time of it trying to detect it on startup. I think this is something that's going to have to be done through the command line in a startup icon, but how is another story. Everything that I have found says after you change the security level, you then have to log out and back in again, so this blows what I had planned as I was going to check the level and store as a global variable on startup, change it when the app opens, then when exiting the app, set it back to the original setting. grrrrrr

The self certs sounded like a good idea, to create them when installed, but then I read that if you create queries and such on the fly that this makes the cert null and void as the code has changed. So what good is it?

At this point, unless I stumble across something else, it looks like I will need to pay approximately $325 for a Digital Cert to distribute with the app and advise the clients to list us as a trusted publisher.

If anyone else has any ideas or finds anything, please post back to the group!

Regards,

Beth M
Reply With Quote
  #3 (permalink)  
Old February 16th, 2004, 03:04 PM
Authorized User
 
Join Date: Nov 2003
Location: Hillsboro, Ohio, USA.
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to bjackman Send a message via MSN to bjackman
Default

I couldn't get that to work as well. The only solution i have found so far is to use the access runtime. The computer i tested on only had the access 2003 runtime files, no actual installation of access and it didn't pop up any of the security warnings boxes. I don't know if that is an option for you or not. If i figure anything else out, i'll post it here.

Branden

Reply With Quote
  #4 (permalink)  
Old February 16th, 2004, 03:40 PM
Friend of Wrox
 
Join Date: Jul 2003
Location: Houston, Texas, USA.
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

That's some good news! We deploy this as runtime but who knows how many actually take the runtime switch out when they have a full install.

Thanks for the info!

Beth M
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
file in a share mode m_rajib74 C# 1 January 24th, 2007 03:25 PM
Detect Edit Mode everest ASP.NET 2.0 Basics 0 December 19th, 2006 05:32 PM
Changing the Mode anukagni Access 1 July 30th, 2006 08:33 PM



All times are GMT -4. The time now is 08:25 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.