• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • Last Modified:

Get past security warning in ms access using scheduled tasks

I have a scheduled task that will open a ms access database and run a macro.  I'm running into a problem when the database is open, I get the security warning prompt.  Is there anyway to get around this?
0
nfstrong
Asked:
nfstrong
  • 2
  • 2
2 Solutions
 
prachwalCommented:
use:
Digital Certificate for VBA Projects
make cert

in VBA editor
Tools -> Digital Signature -> sign as -> chose -> your cert
0
 
prachwalCommented:
chceck box on: Always trust file from this publisher....
and pres ok
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
What version of Access? If this is 2007, you need to add the database to a Trusted Location.

Also: if this is a 2003 or earlier, then you'll not only need to use a digital certificate (a self-certificate may or may not work, by the way), and you'll also need to insure that the machine is running Jet SP 8.0 and that sandbox mode has been enabled.
0
 
nfstrongAuthor Commented:
I'm running 2003.  I created a cert and checked the trust publisher box.  I have a split database where these updates are done on the backend, so I've added the cert to the backend.  My question is if I make an update to the VBA do I have to reinstall the cert on the machine running the updates or will it still work?
0
 
nfstrongAuthor Commented:
I just tested it and it worked!  Thanks for the help!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now