Hi I've completed work on an access2007 database which is to be run on
a network server by many users at the same time. Every time the
database is opened on a new computer I get the "Certain content in
this database has been disabled" warning at the top. How do I avoid
this please? My users would not know to click the bar and enable the
content.
I've tried digital signing but it I can only seem to do it by
packaging the database which brings up an extraction screen every time
it's loaded. Is there any way to bypass this annoying security
warning?
Thanks a lot,
Ciarán
Oct 5 '08
21 4394
This has been an issue for more than 15 years. The Microsoft Access team
identified this as the top reason for corruption in their tech support
incidents.
If you haven't had the problem yet, you will so take good advice when you get
it and split the db file.
Chris
Microsoft MVP
Cron wrote:
>There'll be 30 users max at any one time. I've never had corruption problems in the past with similar setups, why would this be an issue?
--
Message posted via AccessMonster.c om http://www.accessmonster.com/Uwe/For...ccess/200810/1
On Oct 7, 11:08*pm, "Chris O'C via AccessMonster.c om" <u29189@uwe>
wrote:
This has been an issue for more than 15 years. *The Microsoft Access team
identified this as the top reason for corruption in their tech support
incidents.
If you haven't had the problem yet, you will so take good advice when youget
it and split the db file.
hmm... ok point taken. Is it OK to have a shared copy of the front end
linked to a seperate shared copy of the backend?
Nobody shares, really. Only one user per front end. The db file is split
into a back end (contains tables and relationships) and a front end (contains
all other objects and links to the tables). The back end is put on the
network share and a copy of the front end is put on each user's desktop. The
users are linked to the back end tables but they aren't sharing the file
(like they've opened it in Access at the same time). They have a connection
thru the Jet or ACE db driver, but none of those connections are shared with
anybody else's db connection. So if one of those connections gets
disconnected (like a network cable is pulled), it doesn't affect the other
users' sessions.
Chris
Microsoft MVP
Cron wrote:
>Is it OK to have a shared copy of the front end linked to a seperate shared copy of the backend?
--
Message posted via AccessMonster.c om http://www.accessmonster.com/Uwe/For...ccess/200810/1
On Oct 8, 12:25*am, "Chris O'C via AccessMonster.c om" <u29189@uwe>
wrote:
Nobody shares, really. *Only one user per front end. *The db file is split
into a back end (contains tables and relationships) and a front end (contains
all other objects and links to the tables). *The back end is put on the
network share and a copy of the front end is put on each user's desktop. *The
users are linked to the back end tables but they aren't sharing the file
(like they've opened it in Access at the same time). *They have a connection
thru the Jet or ACE db driver, but none of those connections are shared with
anybody else's db connection. *So if one of those connections gets
disconnected (like a network cable is pulled), it doesn't affect the other
users' sessions.
Chris
Microsoft MVP
OK I'll do it like that so. Now back to the matter at hand... does
anyone know a way to add a trusted location to the registry using VBA?
or is there a way to digitally sign a database without packaging it?
Cheers for the help on this guys,
Ciarán
Several flaws in your logic. The vba won't run because the college students
at those hundreds of workstations don't have the smarts to enable the content
by pressing a bar that pretty much says "contents disabled unless you press
here". You don't want to go to those hundreds of workstations yourself to do
it while each user is logged in. (The trusted locations are per user, not
per workstation, so unless the network is set up with roaming profiles - kind
of doubtful - you have a lot more work than you thought if students are
allowed to use more than 1 pc when using your app during the semester.) The
user who's executing the vba code needs to have enough permissions to write
to the registry. Most college networks are locked down so student users
don't usually have those permissions.
What kind of digital signature are you using that needs to be packaged to be
installed on each pc? You can't sign the files on one pc with your digital
certificate and copy the front end to each user's desktop and copy the back
end to the network server?
Chris
Microsoft MVP
Cron wrote:
>does anyone know a way to add a trusted location to the registry using VBA? or is there a way to digitally sign a database without packaging it?
--
Message posted via AccessMonster.c om http://www.accessmonster.com/Uwe/For...ccess/200810/1
On Oct 8, 1:20*am, "Chris O'C via AccessMonster.c om" <u29189@uwe>
wrote:
Several flaws in your logic. *The vba won't run because the college students
at those hundreds of workstations don't have the smarts to enable the content
by pressing a bar that pretty much says "contents disabled unless you press
here". *You don't want to go to those hundreds of workstations yourselfto do
it while each user is logged in. *(The trusted locations are per user, not
per workstation, so unless the network is set up with roaming profiles - kind
of doubtful - you have a lot more work than you thought if students are
allowed to use more than 1 pc when using your app during the semester.) *The
user who's executing the vba code needs to have enough permissions to write
to the registry. *Most college networks are locked down so student users
don't usually have those permissions.
True, but if it was just a once off, I could tell the students to
click the enable content button. It just can't appear every time the
database is opened. You might be right about the registry edits being
disabled altho the settings do allow the change through access so I've
a feeling the security won't be smart enough to distinguish VBA from
access.
>
What kind of digital signature are you using that needs to be packaged tobe
installed on each pc? *You can't sign the files on one pc with your digital
certificate and copy the front end to each user's desktop and copy the back
end to the network server?
I'm not sure if that was a question but I tried this quickly on my
home network and it didnt work but I might have missed something. Is
the following possible...
Create a digital signiture using office.
Sign and package the database with it in access.
Unpack the signed package to a new computer and run as digitally
signed without problems??
Cheers,
Ciarán
That's good news, it should work if you use vba. It's just enabling the vba
that's the problem, so....
Chris
Microsoft MVP
Cron wrote:
>On Oct 8, 1:20Â*am, "Chris O'C via AccessMonster.c om" <u29189@uwe> wrote:
>You might be right about the registry edits being disabled altho the settings do allow the change through access so I've a feeling the security won't be smart enough to distinguish VBA from access.
--
Message posted via AccessMonster.c om http://www.accessmonster.com/Uwe/For...ccess/200810/1
On Oct 8, 1:54*am, "Chris O'C via AccessMonster.c om" <u29189@uwe>
wrote:
That's good news, it should work if you use vba. *It's just enabling the vba
that's the problem, so....
I also don't have a clue how to code it or if it's even possible
through VBA! ... hopefully someone in the neighbourhood will know ...?
Are you using a self cert digital certificate? I've seen it work on a
network of pcs using Access 2003 but that takes a consultant who's a security
expert. (I've never seen it tried in Access 2007, so it might not be
possible on your network.) A normal developer won't be able to do it. A
normal developer needs a Thawte digital certificate or another commercial
certificate provider to distribute digital signatures at the organizational
level.
Chris
Microsoft MVP
Cron wrote:
>On Oct 8, 1:20Â*am, "Chris O'C via AccessMonster.c om" <u29189@uwe> wrote:
>I tried this quickly on my home network and it didnt work but I might have missed something. Is the following possible...
Create a digital signiture using office. Sign and package the database with it in access. Unpack the signed package to a new computer and run as digitally signed without problems??
--
Message posted via http://www.accessmonster.com
Chris O'C via AccessMonster.c om wrote:
Several flaws in your logic. The vba won't run because the college students
at those hundreds of workstations don't have the smarts to enable the content
by pressing a bar that pretty much says "contents disabled unless you press
here". You don't want to go to those hundreds of workstations yourself to do
it while each user is logged in. (The trusted locations are per user, not
per workstation, so unless the network is set up with roaming profiles - kind
of doubtful - you have a lot more work than you thought if students are
allowed to use more than 1 pc when using your app during the semester.) The
user who's executing the vba code needs to have enough permissions to write
to the registry. Most college networks are locked down so student users
don't usually have those permissions.
I haven't migrated to 2007 yet so I don't understand the trusted
location concept you just stated. If I set "C:\A2007\A pps" as a trusted
folder wouldn't it be a trusted folder for all students?
Wouldn't Tony Toews AutoFe be a useful tool for distributing the
application to the students?
>
What kind of digital signature are you using that needs to be packaged to be
installed on each pc? You can't sign the files on one pc with your digital
certificate and copy the front end to each user's desktop and copy the back
end to the network server?
Chris
Microsoft MVP
Cron wrote:
>>does anyone know a way to add a trusted location to the registry using VBA? or is there a way to digitally sign a database without packaging it?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: -Michelle- |
last post by:
Hi
Before anyone blasts me for posting a question that the solution clearly
appears in the help file, please read on.
I keep getting the Security Warning : Opening.. x database may not be safe,
because it could contain harmful code, etc. We all know the warning.
Help says : Go to Tools menu, Macro and click on Security. (Running Office
2003). One slight problem, I don't have the 'security' option as listed.
|
by: Mads W. |
last post by:
Hi,
I'm coding a small program that can create new mails in outlook.
So far I'm avoding the security warning by only displaying the created mail,
and let the user interact to send the mail.
But I would like to be able to send the mail. I know there are ways of
avoiding the security warning throug Outlook redemption. But their sollution
is a little expensive for my use.
Can I somehow avoid in any other way?
|
by: Hatim Ali |
last post by:
Hello folks,
I've integrated my ASP.NET website with a portal on web. My website opens in
a frame provided by the web portal. The portal uses https protocol. Now when
i open my website IE displays a security warning saying "This page contains
both secure and un-secure items. Do you want to display the non secure
items". When i hit yes every thing works fine.
What should i do to remove this security warning. My ASP.NET web page has a...
|
by: Jeyakumar |
last post by:
Hi,
I am using following code to avoid security warning when switch from
pageA(https) to PageB (http).
'Output a redirector for the needed page to avoid a security warning.
Response.Clear()
'Add a refresh header to the response for the new path.
Response.AddHeader("Refresh", "0;URL=PageB.aspx")
|
by: BillE |
last post by:
Some ASP.NET applications use Session Variables extensively to maintain
state.
These should be re-written to use viewstate, hidden fields, querystring,
etc. instead.
This is because if a user opens a new IE window with Ctrl-N or
File-New-Window, BOTH WINDOWS SHARE THE SAME SESSION VARIABLES. This cannot
be prevented.
| |
by: larpup |
last post by:
When running on A2003 runtime with an mde i receive 3 security
warnings.
Do you want to block unsafe expresssions.
Then another security warning
Then, do you want to open this file.
This problem does not occur using a full version of A2003.
Any suggestions how to avoid these unnecessary questions when using
|
by: VancouverMike |
last post by:
Hi there,
I am writing a web app using asp.net 1.1 and C#. This web app is launched in
another win32 application and this app needs to pass information to my web
app. But this win32 application doesn't support long string(Maximum 255),
which gives me problem passing information longer than 255 through
querystring. So I have to use an intermedia plain file and in my web app,
using Scripting.FileSystemObject to open the file and read the...
|
by: vignesh19 |
last post by:
hi.. while i try to send an automated email using outlook, i receive a security warning. how to get rid of that.
|
by: Cron |
last post by:
Hi, I've just completed work on an access 2007 database which will be
run from a network server by many inexperienced users at the same
time. Every time the database is opened, the "content in this database
has been disabled" warning appears at the top and my users would not
think to click options and enable the content.
I have tried digitally signing to avoid the problem but I can only
seem to do it by packaging the database - forcing...
|
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: 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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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
| |