I distribute some Access 2K applications as mde files using the Access2K
runtime.
Now that I am thinking of updating to Access 2003 I find that, when I launch
an mde file, I get a number of warning messages about macros and security
which are a nuisance to the users.
Is there any way of avoiding these messages?
Alec 7 3429
Paradigm wrote: I distribute some Access 2K applications as mde files using the Access2K runtime. Now that I am thinking of updating to Access 2003 I find that, when I launch an mde file, I get a number of warning messages about macros and security which are a nuisance to the users. Is there any way of avoiding these messages? Alec
What I do is use selfcert.exe to create a digital signature that can be
applied to the mdb file. Another twist I came across recently was that
for a certain machine I had to run mmc (Microsoft Management Console)
using the Add/Remove Snap-in option to drag and drop the digital
signature into a Trusted Certificates category. So far I have been
able to get rid of all the warnings. Only a few machines have needed
the digital signature fix so I create the digital signature with the
user's name. I haven't had to do this in a more automated way yet. I
hope this helps.
James A. Fortune ji********@comp umarc.com wrote: Paradigm wrote:
I distribute some Access 2K applications as mde files using the Access2K runtime. Now that I am thinking of updating to Access 2003 I find that, when I launch an mde file, I get a number of warning messages about macros and security which are a nuisance to the users. Is there any way of avoiding these messages? Alec
What I do is use selfcert.exe to create a digital signature that can be applied to the mdb file. Another twist I came across recently was that for a certain machine I had to run mmc (Microsoft Management Console) using the Add/Remove Snap-in option to drag and drop the digital signature into a Trusted Certificates category. So far I have been able to get rid of all the warnings. Only a few machines have needed the digital signature fix so I create the digital signature with the user's name. I haven't had to do this in a more automated way yet. I hope this helps.
James A. Fortune
James, you have selfcert.exe generated certs to work on PCs other than the one the cert
was generated on? That's not supposed to happen...
The "proper" procedure is to get a cert from a Certificate Authority but the cost/process
may be unreasonable for some applications.
There are work arounds ranging from modifying registry settings (that is considered rude
to do to a customer/client without their approval) to using Automation to start Access and
modify the security settings for the immediate session.
If you search this group on "macro security 2003" you should get lots of info.
--
'---------------
'John Mishefske
'--------------- ji********@comp umarc.com wrote: Paradigm wrote:
I distribute some Access 2K applications as mde files using the Access2K runtime. Now that I am thinking of updating to Access 2003 I find that, when I launch an mde file, I get a number of warning messages about macros and security which are a nuisance to the users. Is there any way of avoiding these messages? Alec
What I do is use selfcert.exe to create a digital signature that can be applied to the mdb file. Another twist I came across recently was that for a certain machine I had to run mmc (Microsoft Management Console) using the Add/Remove Snap-in option to drag and drop the digital signature into a Trusted Certificates category. So far I have been able to get rid of all the warnings. Only a few machines have needed the digital signature fix so I create the digital signature with the user's name. I haven't had to do this in a more automated way yet. I hope this helps.
James A. Fortune
James, you have selfcert.exe generated certs to work on PCs other than the one the cert
was generated on? That's not supposed to happen...
The "proper" procedure is to get a cert from a Certificate Authority but the cost/process
may be unreasonable for some applications.
There are work arounds ranging from modifying registry settings (that is considered rude
to do to a customer/client without their approval) to using Automation to start Access and
modify the security settings for the immediate session.
If you search this group on "macro security 2003" you should get lots of info.
--
'---------------
'John Mishefske
'---------------
John Mishefske wrote: James, you have selfcert.exe generated certs to work on PCs other than the one the cert was generated on? That's not supposed to happen...
I'm sorry for being unclear on this point. I use selfcert.exe on the
target PC. After that, I usually modify the mdb by importing the
changes rather than compacting so that I don't have to create the
Digital Signature again.
The "proper" procedure is to get a cert from a Certificate Authority but the cost/process may be unreasonable for some applications.
I'm not aware of any EULA's being violated by using selfcert.exe. For
a custom app selfcert.exe seems quite "proper." I certainly trust the
author :-). In what situations would a cert from a Certificate
Authority be useful?
There are work arounds ranging from modifying registry settings (that is considered rude to do to a customer/client without their approval) to using Automation to start Access and modify the security settings for the immediate session.
I definitely don't want to change any registry settings. With
selfcert.exe I don't have to change the security settings at all.
If you search this group on "macro security 2003" you should get lots of info.
That's a possibility. I'm more interested in why I had to do the
Trusted Sources for only one particular machine.
James A. Fortune
John Mishefske wrote: James, you have selfcert.exe generated certs to work on PCs other than the one the cert was generated on? That's not supposed to happen...
I'm sorry for being unclear on this point. I use selfcert.exe on the
target PC. After that, I usually modify the mdb by importing the
changes rather than compacting so that I don't have to create the
Digital Signature again.
The "proper" procedure is to get a cert from a Certificate Authority but the cost/process may be unreasonable for some applications.
I'm not aware of any EULA's being violated by using selfcert.exe. For
a custom app selfcert.exe seems quite "proper." I certainly trust the
author :-). In what situations would a cert from a Certificate
Authority be useful?
There are work arounds ranging from modifying registry settings (that is considered rude to do to a customer/client without their approval) to using Automation to start Access and modify the security settings for the immediate session.
I definitely don't want to change any registry settings. With
selfcert.exe I don't have to change the security settings at all.
If you search this group on "macro security 2003" you should get lots of info.
That's a possibility. I'm more interested in why I had to do the
Trusted Sources for only one particular machine.
James A. Fortune ji********@comp umarc.com wrote: John Mishefske wrote:
James, you have selfcert.exe generated certs to work on PCs other than the one the cert was generated on? That's not supposed to happen...
I'm sorry for being unclear on this point. I use selfcert.exe on the target PC. After that, I usually modify the mdb by importing the changes rather than compacting so that I don't have to create the Digital Signature again.
Ahh.. I see. I haven't tried that...
The "proper" procedure is to get a cert from a Certificate Authority but the cost/process may be unreasonable for some applications.
I'm not aware of any EULA's being violated by using selfcert.exe. For a custom app selfcert.exe seems quite "proper." I certainly trust the author :-). In what situations would a cert from a Certificate Authority be useful?
Didn't mean to imply anything nefarious; only that Microsoft would encourage you to follow
a procdure to get a cert. I don't do it since my clients aren't interested in the extra
expense and lack of benefits for our particular market. There are work arounds ranging from modifying registry settings (that is considered rude to do to a customer/client without their approval) to using Automation to start Access and modify the security settings for the immediate session.
I definitely don't want to change any registry settings. With selfcert.exe I don't have to change the security settings at all.
Agreed. If you search this group on "macro security 2003" you should get lots of info.
That's a possibility. I'm more interested in why I had to do the Trusted Sources for only one particular machine.
Not sure about that; perhaps someone reading this has experienced this problem and
identified the cause?
--
'---------------
'John Mishefske
'--------------- ji********@comp umarc.com wrote: John Mishefske wrote:
James, you have selfcert.exe generated certs to work on PCs other than the one the cert was generated on? That's not supposed to happen...
I'm sorry for being unclear on this point. I use selfcert.exe on the target PC. After that, I usually modify the mdb by importing the changes rather than compacting so that I don't have to create the Digital Signature again.
Ahh.. I see. I haven't tried that...
The "proper" procedure is to get a cert from a Certificate Authority but the cost/process may be unreasonable for some applications.
I'm not aware of any EULA's being violated by using selfcert.exe. For a custom app selfcert.exe seems quite "proper." I certainly trust the author :-). In what situations would a cert from a Certificate Authority be useful?
Didn't mean to imply anything nefarious; only that Microsoft would encourage you to follow
a procdure to get a cert. I don't do it since my clients aren't interested in the extra
expense and lack of benefits for our particular market. There are work arounds ranging from modifying registry settings (that is considered rude to do to a customer/client without their approval) to using Automation to start Access and modify the security settings for the immediate session.
I definitely don't want to change any registry settings. With selfcert.exe I don't have to change the security settings at all.
Agreed. If you search this group on "macro security 2003" you should get lots of info.
That's a possibility. I'm more interested in why I had to do the Trusted Sources for only one particular machine.
Not sure about that; perhaps someone reading this has experienced this problem and
identified the cause?
--
'---------------
'John Mishefske
'--------------- This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Noesis Strategy |
last post by:
When I ordered my new laptop, Sony didn't offer Access 2003 in its bundles.
Recently, I have begun to design Access databases using an copy of Access
2002 from my previous laptop. It works fine, but I would like to have all
the office apps on the same version. So I have a few questions:
1) Is the file format the same as 2002? Can 2002 users read 2003 files?
2) What are the major reasons for upgrading to 2002 ?
|
by: RM |
last post by:
Had VS .Net 2002 installed on W2k Server SP3 and supported
a number of web sites. Installed VS .Net 2003 on Friday and now
all web sites using .Net & MS ACCESS get this strange error upon open.
ASP=/TestDotNet/AdoNet.aspx
System.Data.OleDb.OleDbException: Unspecified error at
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbConnection.InitializeProvider()
at System.Data.OleDb.OleDbConnection.Open()...
|
by: Rachel |
last post by:
Hi,
I am using the data access application block successfully in our development
environment, however when I deploy to our testing server as Private
Assemblies I keep getting the following
Configuration Error
Description: An error occurred during the processing of a configuration file
required to service this request. Please review the specific error details
below and modify your configuration file appropriately.
|
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: Mell via AccessMonster.com |
last post by:
I created databases on Access 2003 and I want to deploy them to users. My
code was also done using 2003.
If they have Ms Access 2000 or higher, will they be able to use these dbs
with all code, etc?
Please explain
--
Message posted via http://www.accessmonster.com
| |
by: Mell via AccessMonster.com |
last post by:
Is there a way to find out where an application was created from?
i.e. - work or home
i.e. - if application sits on a (work) server/network, the IT people know the
application is sitting there, but is there a way they can find out if that
application was put there from a CD or email or created at work?
Hint: It's not on a client/server database, just native jet database mdb
created on Access 2003 (default 2000)...
|
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: Walshi |
last post by:
Hi all,
I'm a relative newby to access and VBA etc. My forms and tables etc are
working great and saving lots of time...However...
I have two databases with the exact same table format. I want db1 to be
used to input data by a remote operator, when she is ready I want her
to be able to click a control button to email her new data to db2. This
new data will be added to the table in db2 ready for further
processing.
|
by: Prakash |
last post by:
I am developing an HR package under Access 2003 for a client but do not
want to give him the source code.
I understand that under these circumstances I would need to compile my
package, thus converting it into an MDE file. How do I go about doing
this & what would the client need to have installed on his PC ? i.e.
(Would the client need to have Access installed on his PC ?)
I currently own a copy of MS Office Professional Edition 2003.
|
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: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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: 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: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |