Security on for all dbs!

P

PsyberFox

Hi,

I have activated the security and set up groups, etc on a db. But, now when
I open any other Access db, it also asks for the Admin password. Is it
supposed to happen?

Ciao
 
T

Tom van Stiphout

On Wed, 12 Mar 2008 04:42:02 -0700, PsyberFox

You seem surprised. If you had downloaded, studied, and fully
understood the Access Security FAQ from microsoft.com you wouldn't be.

Workgroup security is an advanced topic. You just can't guess at it.

-Tom.
 
P

PsyberFox

I realise it's an advance topic, but a yes or no would've been nice...
thank you for your reply though
W
 
J

Joan Wild

It's not likely what you want, no.

Access ships with system.mdw and security is already implemented whenever you use Access. For all databases, it uses this system.mdw file and silently logs you in as the 'Admin' user which has full privileges.

Once you set a password for the Admin user, the login is no longer silent and you get the login prompt.

When you create a new mdw file, Access makes that the default one to use. This is why you are getting the login for all databases.

You can use wrkgadm.exe to rejoin the system.mdw file as your default.

You can use wrkgadm.exe to switch between different mdw files(tedious) or use a desktop shortcut just for your secure mdb. The target in the shortcut can use the /wrkgrp switch to tell Access to use a different mdw file for this session. Leave your default mdw as system.mdw.

The target would look like
"path to msaccess.exe\msaccess.exe" "path to your db\db1.mdb" /wrkgrp "path to your mdw\secure.mdw"

The security FAQ is available for download at
http://support.microsoft.com/?id=207793

I assume that you started by creating a new mdw, and didn't just start adding groups/users, etc. If you didn't create a new mdw, then you've missed a critical step and will never secure your mdb.
 
P

PsyberFox

Thank you so much!

I have the FAQ, but didn't fully understand the situation w.r.t. multiple
databases. Also, my end-users won't be able to "switch" between secured and
unsecured because of the level of skill involved. The runtime switch, however
tedious, will work wonders though!

Thank you again!
W
 
R

Rick Brandt

PsyberFox said:
Thank you so much!

I have the FAQ, but didn't fully understand the situation w.r.t.
multiple databases. Also, my end-users won't be able to "switch"
between secured and unsecured because of the level of skill involved.
The runtime switch, however tedious, will work wonders though!

They don't need to "switch". You give them a shortcut they specifies the
secure workgroup for files where it is needed and they open non-secure files
the way they always have. It is almost never a good idea to "join" a
secured workgroup. Frankly I don't know why it was even made an option.
 
T

Tom van Stiphout

On Wed, 12 Mar 2008 23:28:39 GMT, "Rick Brandt"

Amen to that. Rather provide a shortcut using:
<full_path_to>msaccess.exe <full_path_to>the_mdb /wrkgrp
<full_path_to>workgroupfile.mdw

-Tom.
 
P

PsyberFox

Thank you all for your help!!!
W

Tom van Stiphout said:
On Wed, 12 Mar 2008 23:28:39 GMT, "Rick Brandt"

Amen to that. Rather provide a shortcut using:
<full_path_to>msaccess.exe <full_path_to>the_mdb /wrkgrp
<full_path_to>workgroupfile.mdw

-Tom.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top