How to remove Security Notice from Access 2007 Runtime?

[banem2]

Is it possible?

Users of my program does not understand why they need to click "Open"
each time they run program under runtime. I have digitally signed
database and user has runtime only installed.

Imagine if we need to click Open each time we run executable. It is
very annoying.

Thanks,
Branislav

 

[Tony Toews [MVP]]

Is it possible?

Users of my program does not understand why they need to click "Open"
each time they run program under runtime. I have digitally signed
database and user has runtime only installed.

What is the exact message they are seeing? Have you signed the MDE?

Unfortunately I know next to nothing about signing.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[banem2]

What is the exact message they are seeing? Have you signed the MDE?

Unfortunately I know next to nothing about signing.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/

Hi Tony,

Message is a bit longer. It starts with:

"A potential security concern has been identified. Warning: It is not
possible to determine that..."

"... The file might contain unsafe content that could harm your
computer. Do you want to open this file or cancel operation?"

Buttons: [Open] [Cancel]

I am wondering - does any EXE file contain code which can harm your
computer?

I have digitally signed MDB (not MDE) and build installation package
using Access 2007 Developer package. However it opens on my PC without
warning message, but user complains it must click "Open" to run
program.

I remember that developers of Access 2007 runtime have told us they
will remove this message from runtime, but it still appears. As in
runtime I don't have a way to add database to trusted locations, I
don't see a way how to remove this message. Actually it is very
annoying. If we need to click "Open" for each EXE program I am
wondering what we will tell to MS?

For Access 2003 I can set that using .REG file. Are there similar
solution for MS Access 2007?

Thanks,
Branislav

 

[banem2]

What is the exact message they are seeing? Have you signed the MDE?

Unfortunately I know next to nothing about signing.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/

Hi Tony,

Message is a bit longer. It starts with:

"A potential security concern has been identified. Warning: It is not
possible to determine that..."

"... The file might contain unsafe content that could harm your
computer. Do you want to open this file or cancel operation?"

Buttons: [Open] [Cancel]

I am wondering - does any EXE file contain code which can harm your
computer?

I have digitally signed MDB (not MDE) and build installation package
using Access 2007 Developer package. However it opens on my PC without
warning message, but user complains it must click "Open" to run
program.

I remember that developers of Access 2007 runtime have told us they
will remove this message from runtime, but it still appears. As in
runtime I don't have a way to add database to trusted locations, I
don't see a way how to remove this message. Actually it is very
annoying. If we need to click "Open" for each EXE program I am
wondering what we will tell to MS?

For Access 2003 I can set that using .REG file. Are there similar
solution for MS Access 2007?

Thanks,
Branislav

BTW I am moving back to Access 2003 runtime. There are
incompatibilities all the way. Here are some stupid:

- Close button on Report Toolbar won't close report
- Export To from same toolbar crash program. It cannot export to any
of the formats.
- I am showing welcome screen and after 2 seconds log-in screen
(custom). Program crash on some of the PC's on simple DoCmd.OpenForm
and DoCmd.Close acForm
- DoCmd.TransferSpreadsheet crashes runtime

At the same time all is tested well on both Access 2003 and 2007!

Then:

- Speed is considerably lower, while memory usage is noticeable higher
- Runtime is almost twice in size larger
- On first run Access 2007 deletes all my VBA code without warning
- Zillion of other annoying things (too long list) including "Unsafe
program, click Open" (which one IS safe?)

So I am moving back to Access 2003 and I will remove any and last byte
of Office 2007. It is a toy for playing, not a serious program.

Regards,
Branislav
Branislav

 

[Tony Toews [MVP]]

BTW I am moving back to Access 2003 runtime.

Yikes, quite a list of problems there. I haven't played around with
A2007 much simply because it takes so long to switch between A2007 and
other versions of Access.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/