By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,880 Members | 2,279 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,880 IT Pros & Developers. It's quick & easy.

Advanced Access Security problem

P: n/a
I had a useracct called xxx123 I had set up.
Now there is a problem in that **every single** .mdb file I open now on
my PC (regardless of age of the file, location of the file, etc) now
asks for that ID and password.
So I concluded there was some system file somewhere on my PC that
contained some userid/password info that was set up through
Tools/Security.
(Obviously I did not configure the security correctly...you don't need
to scold me on that one)

To try and get rid of the userid when *any* .mdb file would be
launched, I uninstalled Access 2002 completely, powered my PC totally
off for 10 minutes, powered back up, then reinstalled Access 2002.
Guess what? The same problem exists. There is a file somewhere on my
system that has this security bit in there that **still** asks for a
userid/pass regardless of any .mdb file I try to open.
Is there another place I can look on my PC to try and get rid of it?

Thanks.

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"TechBoy" <rl**********@yahoo.com> wrote in
news:11**********************@g44g2000cwa.googlegr oups.com:
To try and get rid of the userid when *any* .mdb file would be
launched, I uninstalled Access 2002 completely, powered my PC
totally off for 10 minutes, powered back up, then reinstalled
Access 2002. Guess what? The same problem exists. There is a
file somewhere on my system that has this security bit in there
that **still** asks for a userid/pass regardless of any .mdb file
I try to open. Is there another place I can look on my PC to try
and get rid of it?


Out of the box, the way Jet user-level security works is that by
default, you are passively logged in as the Admin user, with no
password. If you set a password for the admin account, however, you
will then be prompted for a username and password.

What that means for your situation is that the admin account in your
default system.mdw has a password set on it. Since you don't seem to
know anything about that, it's unlikely you'll know the password and
find yourself able to log on as admin and change to a blank
password.

Here's what I would recommend you do:

1. shut down all instances of Access.

2. use Windows FIND to locate all copies of System.mdw. Rename them
all to something else.

3. run Office (or Access) Setup and repair your installation.

What this accomplishes is that the now-misssing system.mdw (which
you had renamed) will be replaced with a new copy, with no password
on the admin account.

Last of all, this is not an advanced Access security question at all
-- it's the most basic aspect of Jet user-level security that there
is.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #2

P: n/a
You need to rejoin the original, unsecured workgroup file (system.mdw)
by using the workgroup administrator (Tools > Security > Workgroup
Administrator). If you mistakenly created accounts in your default
workgroup, you can delete it, and Access will recreate a new one when
it runs.

Then use a desktop shortcut to join the secured workgroup file by
putting the correct information in the shortcut's target:
<fullPathToAccessExecutable> <fullPathToMDBFile> /wrkgrp
<fullPathToWorkgroupFile>

See the website in my signature for links to documents that will
explain more fully.

On 19 Jul 2005 15:44:41 -0700, "TechBoy" <rl**********@yahoo.com>
wrote:
I had a useracct called xxx123 I had set up.
Now there is a problem in that **every single** .mdb file I open now on
my PC (regardless of age of the file, location of the file, etc) now
asks for that ID and password.
So I concluded there was some system file somewhere on my PC that
contained some userid/password info that was set up through
Tools/Security.
(Obviously I did not configure the security correctly...you don't need
to scold me on that one)

To try and get rid of the userid when *any* .mdb file would be
launched, I uninstalled Access 2002 completely, powered my PC totally
off for 10 minutes, powered back up, then reinstalled Access 2002.
Guess what? The same problem exists. There is a file somewhere on my
system that has this security bit in there that **still** asks for a
userid/pass regardless of any .mdb file I try to open.
Is there another place I can look on my PC to try and get rid of it?

Thanks.

**********************
ja**************@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
Nov 13 '05 #3

P: n/a
RLN

Thanks Jack, I appreciate your assistance. That worked fine.


*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.