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

Cron wrote:
On each user's PC the folder where the file is stored needs to be set as a
"trusted folder". This is in the Access options.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Surely there's a better way to do it than this?? The network is in a
busy college with hundreds of workstations. It's not practical to set
it on every machine. Is there no way to digitally sign a database
without having to package it?

Cheers,
Ciarán

Cron wrote:
It can be done programmatically as it is just a registry entry. Sorry, I am
not familiar with the specifics of digital certificates.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Yes I've actually tried writing a .reg file for it but reg edits are
blocked on the college workstations! It's dead ends in all directions!
Ciarán

"Cron" <cronoklee (AT) hotmail (DOT) com> wrote


How are you going to get a copy of the front-end onto those workstations?
Can the same script be used to set the destination folder as trusted?

Hi, thanks for the reply... The databse is installed on a shared
network drive and can be accessed by all workstations simultaneously.

Is there any VBA code that can add trusted locations as executing
a .reg file manually is forbidden on the college workstations?

Cheers,
Ciarán

"Cron" <cronoklee (AT) hotmail (DOT) com> wrote


Access should not be run this way. Each user should have a copy of the
front-end linked to a shared copy of the back-end otherwise you will have
corruption of the MDB. The Jet Back-end may need to be changed to SQL server
if you have100's of simultaneous users.

Are the workstations connected to the server with Active Directory? If so,
can your system administrator add the keys though a group policy?

On Oct 7, 1:31*pm, "paii, Ron" <n... (AT) no (DOT) com> 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?

I have no idea how the server is set up. As far as I can tell it's
simply a windows mapped network drive. I'd prefer an access only
solution as the admins are very busy and could take weeks or months to
add the keys.


Cheers,
Ciarán

Cron wrote:

Good luck!

Consider a runtime version of A2007. It's free.