Access database security

[skennd]

I have an Access database and secured it in a multi share network.

However, after having created a workgroup and all users are
successfully added and later joined, now anytime any user tries to
access another unrelated MS Access database even though being a
non-secured Access it will prompt for the user the same user and
password for the secured database.

Please help if you know what's causing the secured database to be
confused with non secured other databases.

 

[Joan Wild]

Access always uses a workgroup file, even for unsecured databases.

It uses which ever one is defined as the default for all sessions.

Because you 'joined' your secure mdw, that has become the default.

You should rejoin the standard system.mdw that ships with Access, and create
a desktop shortcut for your secure mdb. The shortcut will use the /wrkgrp
switch which will override the default for just that session.

The target of the shortcut would look like:
"Path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"

 

[Guest]

Basically, when you create your access sercurity using the wizard, you probably
set the option "I want to set this workgroup file as default". As a result
all access
application will be open via that workgroup file. That option is more like a
system
setting. It should be more specific tailor to single access database, but
that just how it works.

One solution is to recreate your mdw file using the wizard and to create a
shortcut
to your secure database. This icon will specifically tailor to just that
database.

 

[skennd]

Thank you Dan,

In fact, it seems that's the problem I am encountering a default
setting. But I didn't quite get exactly how to create a shortcut to my
secure database.

what are the steps involved in creating a shortcut to the secure
database?

 

[skennd]

Thanks Joan,

I didn't see your message before I replied to Dan's.

 

[Guest]

Steps:
1. Start the User-Level sercurity wizard
2. Choose to modify a existing mdw file or create a new one
3. Click Next
4. Choose the option that saids create " shortcut to connect to your
sercurity enhanced database"

Complete the wizard process, the icon should be automatically create.

You can examine the properties of icon after it has been created. Basically
the
icon wil open the mdb or mde file you selected with the specific mdw file
you just
created