I understand that when using Access 2003, the security settings prevent
the VBA code from running correctly and need to be set to the Low
setting. My question is: Can this be done automatically using VBA, in
other words, when my DB opens can it check to see if running Access 2003
and if so then change the macro security settings to low?
Regards 2 2845
"Ntl News Group" <ia********@ntl world.comwrote in message
news:RW******** **********@news fe4-win.ntli.net...
>I understand that when using Access 2003, the security settings prevent the VBA code from running correctly <snip>
What makes you think that? Have you tired running code? I work for a
corporation whose policy forces macro security to the "medium" setting and
my code runs just fine.
Keith. www.keithwilby.com
On Thu, 11 Jan 2007 13:27:13 GMT, Ntl News Group
<ia********@ntl world.comwrote:
These warnings were designed to alert users of macro viruses. If it
could be set programmaticall y, that would defeat the purpose, wouldn't
it?
The correct way to get around these warnings is to digitally sign your
app with a VBA Certificate. Plenty of info about that in the Help
file.
-Tom.
>I understand that when using Access 2003, the security settings prevent the VBA code from running correctly and need to be set to the Low setting. My question is: Can this be done automatically using VBA, in other words, when my DB opens can it check to see if running Access 2003 and if so then change the macro security settings to low?
Regards
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Mark Lees |
last post by:
Whenever I open a DB in 2003 I get the security warning box. How do I
disable that screen?
The Access help suggests.....
Change the security level for macro virus protection by
On the Tools menu, point to Macro, and then click Security.
Click the Security Level tab, and then select the security level you
want to use.
However there is no Security option under the Macro option under
|
by: Jeff Keller |
last post by:
I've built all of my apps in Access 97, but I think it's time I moved
to some newer technology (a little late to the web app game...) so I'm
considering an upgrade. Any reason not to go straight to 2003 and
skip 2000/2002? Will Access 2003 create issues for clients that are
still running Win98/2000? What else do I need to consider?
Any guidance would be helpful
thanks-
jeff
|
by: ANSWER |
last post by:
When I open my database I get next message: This file may not be safe if it
contains code that was intended to harm your computer. Do you want to open
this file or cansel the operation? Cancel, Open, More Info.
I click on more info and the instruction is next:
Preventing macro security warnings
To stop displaying macro warnings, change the security level to Low on the
Security Level tab (on the Tools menu, point to Macro, and click...
|
by: Dave Stone |
last post by:
Last week I posted as follows, but no-one responded:
" I have security level 'Medium' and expression blocking set. If I set
security to 'Low', I get a dialog box which asks if I want to enable
expression evaluation. Irrespective of whether I respond 'Yes' or 'No', the
security level now shows as 'Low' and databases open thereafter without any
warning dialogs. The only operational difference is that I'm prompted to
restart Access if I...
|
by: Peter L Reader |
last post by:
I have to say, from a practical standpoint I'm not all that impressed
with the security built into Office 2K3. I'm a small-scale developer
building Access apps for a few non-profits locally; I find that in
order for me to build and deliver an app that will run without a bunch
of scary nag screens, I have to buy a digital certificate from Thawte
or somebody for a hundred and a half per year or so...otherwise, they
get the "unsafe macro"...
| |
by: Access |
last post by:
Okay I know this is probably not the best way to be doing things but I
have an ancient application that was working fine until a end user got
a new machine. The Access database is performing a mail merge. The
Word Document is linked to a temp table in the Access database. It
used to work fine in the past with DDE. Yes it opens another copy of
the database but it doesn't really matter and it worked.
So now with Access 2003 and Word...
|
by: Neil |
last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is
upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server
at the same time. We're moving to SQL Server 2005, and, since he already has
licenses for Office Pro 2002, he wants to upgrade to that.
I've been saying that we need to upgrade to Access 2003, not 2002, even if
Office is kept at 2002. We are also looking to do a fair amount of...
|
by: Reggie |
last post by:
Hi and TIA. I developed several A2K dbs which are now being run on my
clients computer which have been upgraded to Access 03. I'm not sure
exactly what they mean but of you know or could point me in a direction
to find info on how to prevent and/or fix the db's so that these
message don't pop up when the app is started. Error messages below:
1. Microsoft Jet 4.0 service pack 8 must be installed to block unsafe
expressions without...
|
by: ARC |
last post by:
Hello All,
I have a major application for quoting and invoicing that is written in
Access 97 (both front and back ends). I have a user base of over 300
customers, and currently I don't require that they have Access 97, as I use
the access 97 runtime scripts from Sagekey software. The main problems I've
seen with Access 97 are the built in e-mail support for sending reports.
Unless a user uses the MS Outlook 2000/XP method, they have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |