Password???

  • Thread starter Thread starter Jared
  • Start date Start date
J

Jared

I placed a password-protected database on LAN for users'
access. However, when you open another or new database, a
prompt appears for a database password, even though you
did not set a database password for the database. Once you
set a password for a particular database, does Access put
the same password criteria on the application as a whole?
If so, how can I get around or undo this?
 
There are two types of passwords - one is the database password which
applies to just that database. The prompt asks only for a password.

Creating groups/users type of security also uses passwords, however the
prompt is for a username and password.

You say you are only getting a password prompt? This is unlikely. If in
fact it is a username/password prompt, then you are joined to a 'secure'
workgroup by default. This type of security applies to the Access session,
not to a specific database.

Use Tools, security, workgroup administrator to rejoin system.mdw. To
launch your secure database, use a desktop shortcut to specify the secure
workgroup.
 
I built a database and I secured it by using the "User
Level Security Wizard" in the tools menu. Since I have
done this every database I try to open I need to create a
shortcut to link the database to a secured workgroup group
to access it. If I create a new database I click on the
Access icon, select new database, name and save my new
database and then a prompt comes up requesting a user id
and password. I the secured database that I have must
have user id/password protection due to the amount of
users and levels of users access. I don't want every
database I create or open on my PC to require a user id
and password. If I’m confusing you or you need further
information please contact me @ (e-mail address removed).
This issues is causing problems with a transferdatabase
function I need to use to move a table form one database
to another weekly. All your help is greatly appreciated!!!
 
Hi Jared,

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.

When you decide that you want to secure a database and have uesrs log in,
you create a new workgroup file (mdw); the wizard did this for you.

What it also does is it makes this new workgroup file the new default mdw to
use for all sessions. That is why you are getting a login prompt for all
databases. The login is tied to the Access session, not to a specific
database. There can only be one default at a time.

Open Access (but not any database). Use Tools, Security, Workgroup
Administrator, and choose join to rejoin the system.mdw that ships with
Access. It has no groups/users/passwords in it and you won't get a login
prompt using it.

For your secure database, you'll need to rejoin your secure mdw. You can
use Workgroup Administrator.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"

Actually it's likely that the wizard created a desktop shortcut for you,
unless you said no. You can give your users this same shortcut.

The security FAQ is available for download at
http://support.microsoft.com/?id=207793
 
Thanks a lot Joan for all your help!!! I have one more
question. I'm trying to use VBA code to transfer a table
form one database to another. First the script goes to
the destination database and deletes the old table then
exports the updated table to the destination database.
This works just fine but I need to have the destination
database to be protect by a password (not user id and
password, just password) and when I applied a password to
the database the script that I have written stop working.
The script, when ran, prompts for a password and I enter
the password. Then the script comes back stating "Access
cannot find the object Direct Summary" (Direct Summary is
the name of the table). So, I took the password off the
destination database and reran the script and it worked
perfectly again. My questions is... Do you know the VBA
code that allows me to open an Access database and
automatically enters my password?

If more information is needed to assist me help this issue
please contact me!

Thanks a lot you have been very kind and helpful!!!
 
Instead of deleting a table in db2 and then exporting the table from db1 all
the time.... why not just open db2 and create a *link* to the table in db1?

Simplify you life - also you should realize that the simple database
password is so easily hacked, it's not worth the hassle.
 
OK, thanks. The second database is only protected by a
simple password because I have several pivot tables in
Excel that use the data in these tables. I wasn't able to
use the tables as a data source in the secured database.
I tried using pivot tables in Access but they seem to do
nothing more than just open excel and create them in
excel. This seems like it would confuse my users. When
the drilldown on a cell in the pivot table it open excel
then pulls up a sheet with the specified data. What do
you suggest is a better way to secure db2 and still be
able to use my pivot tables in Excel?

Again you have been such a huge help to me, thanks a lot!
 
Sorry, I don't have experience using pivot tables in Excel, but I still
don't see why your first database with the password on it can't just have a
link to the table in db2 that is the source.
 
Thanks a lot for all your help!! I'll keep researching to
find my answers about the pivot tables!

Thanks again!
 
Back
Top