|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
VBA Macro Security Alertalways choose to enable the content on the database and would like to stop having to do this every time we open it. Does anyone have any advice? Thanks in advance! Courtney Security Warning: Cerntain content in the database has been disabled Options: VBA Macro Access has disabled potentially harmful content in this database. If you trust the contents of this database and would like to enable it for this session only, click Enable this content. Warning: It is not possible to determine that this content came from a trustworthy source. You should leave this content disabled unless the content provides critical functionality and you trust its source. Help protect me from unknown content (recommended) Enable this content. Either digitally sign the db or set your macro security on low.
Tools > Macro > Security. Security level = low. Chris Courtney G wrote: Show quoteHide quote >Every time we open the database we are given the below security warning. We >always choose to enable the content on the database and would like to stop >having to do this every time we open it. Does anyone have any advice? > >Thanks in advance! > >Courtney > >Security Warning: Cerntain content in the database has been disabled >Options: > >VBA Macro >Access has disabled potentially harmful content in this database. >If you trust the contents of this database and would like to enable it for >this session only, click Enable this content. > >Warning: It is not possible to determine that this content came from a >trustworthy source. You should leave this content disabled unless the >content provides critical functionality and you trust its source. > >Help protect me from unknown content (recommended) >Enable this content. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200906/1 Thanks Chris. How can I digitally sign it?
Show quoteHide quote "Chris O'C via AccessMonster.com" wrote: > Either digitally sign the db or set your macro security on low. > > Tools > Macro > Security. Security level = low. > > Chris > > > Courtney G wrote: > >Every time we open the database we are given the below security warning. We > >always choose to enable the content on the database and would like to stop > >having to do this every time we open it. Does anyone have any advice? > > > >Thanks in advance! > > > >Courtney > > > >Security Warning: Cerntain content in the database has been disabled > >Options: > > > >VBA Macro > >Access has disabled potentially harmful content in this database. > >If you trust the contents of this database and would like to enable it for > >this session only, click Enable this content. > > > >Warning: It is not possible to determine that this content came from a > >trustworthy source. You should leave this content disabled unless the > >content provides critical functionality and you trust its source. > > > >Help protect me from unknown content (recommended) > >Enable this content. > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200906/1 > > Buy a digital certificate good for 1 yr from Thawte or VeriSign or one of the
other recognized digital signature companies. Install it on your PC and use the certificate to sign your file (the company gives you instructions). Distribute the file. Everybody who opens your db file can choose to trust your digital signature. Afterwards they don't get the macro security warning when opening files you've digitally signed. Only costs $100 to $250 a year for each digital certificate. You have to buy a separate digital certificate for Microsoft Office files because the digital certificate used to sign executables won't work with Microsoft Office files. Chris Courtney G wrote: >How can I digitally sign it? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200906/1  
Other interesting topics
MS Access program protection
Need Help Adding user lvl Security to 2007 version Understandable documentation regarding Access DBA security users set their own password Access security behavour Comments for Software Copy Protection Solutions Workgroup permissions for Access 97 DB (permissions error) Allow a Disk as a Trusted Location or disable it entirely Trace a user in network version of database Secured Access to Forms |
|||||||||||||||||||||||
