Logon problem

  • Thread starter Thread starter Lawrence
  • Start date Start date
L

Lawrence

Greetings,

I have several Access DBs on a network shared drive. I wanted to add
security to one of them, but decided to be cautious and copy the DB to
another shared folder on the same server and try adding security to it
before I tried it on the 'real' DB. After I used the Security Wizard
and tried a few things, I deleted all the files on the new shared
folder (the MDB and the MDW files) thinking any changes I made would
be local to that share. Then when I tried to open one of the 'real'
DBs I got a logon prompt. I tried all the accounts and passwords I
used on the test DB, but none work. The error message reads "Not a
valid account name or password".

Whatever is causing this seems to be local to the PC is was using to
test. When I log onto a different PC I can open any of the 'real' DBs
with on logon prompt.

Any suggestions would be greatly appreciated. Thanks.

Lawrence
 
-----Original Message-----

Greetings,

I have several Access DBs on a network shared drive. I wanted to add
security to one of them, but decided to be cautious and copy the DB to
another shared folder on the same server and try adding security to it
before I tried it on the 'real' DB. After I used the Security Wizard
and tried a few things, I deleted all the files on the new shared
folder (the MDB and the MDW files) thinking any changes I made would
be local to that share. Then when I tried to open one of the 'real'
DBs I got a logon prompt. I tried all the accounts and passwords I
used on the test DB, but none work. The error message reads "Not a
valid account name or password".

Whatever is causing this seems to be local to the PC is was using to
test. When I log onto a different PC I can open any of the 'real' DBs
with on logon prompt.

Any suggestions would be greatly appreciated. Thanks.

Lawrence

__________________________________________________________ _____________________
Posted Via Uncensored-News.Com - Accounts Starting At
$6.95 - http://www.uncensored-news.com
<><><><><><><> The Worlds Uncensored
News Source said:
.
Try entering "Admin" as the user and a blank for the
password to see if it allows you access
 
Lawrence said:
Greetings,

I have several Access DBs on a network shared drive. I wanted to add
security to one of them, but decided to be cautious and copy the DB to
another shared folder on the same server and try adding security to it
before I tried it on the 'real' DB. After I used the Security Wizard
and tried a few things, I deleted all the files on the new shared
folder (the MDB and the MDW files) thinking any changes I made would
be local to that share. Then when I tried to open one of the 'real'
DBs I got a logon prompt. I tried all the accounts and passwords I
used on the test DB, but none work. The error message reads "Not a
valid account name or password".

Whatever is causing this seems to be local to the PC is was using to
test. When I log onto a different PC I can open any of the 'real' DBs
with on logon prompt.

Any suggestions would be greatly appreciated. Thanks.

Access security is not "per file". It is "per session". In each session
started Access will either use the mdw file specified as a command line
argument or it will use the default mdw file for the current user.

When you created a new "secure" mdw file Access also made that mdw file
your default. So you will always get a login prompt unless you specify a
different mdw file when launching Access by using a command line argument
or unless you change your default mdw back to an unsecured mdw file.

Access security is not trivial. Before going any further with it I would
get the FAQ from MS and read it thoroughly several times through.
 
On Wed, 12 Nov 2003 11:17:20 -0800, "Jeri"

Thanks for your reply, Jerri. Actually I did try Admin
with a blank password but it didn't work.
 
On Wed, 12 Nov 2003 13:27:31 -0600, "Rick Brandt"

Thanks for your reply Rick. Could you point me to where I can
read about how to change my default mdw back to an unsecured
mdw file? Thanks.

Lawrence
 
Lawrence said:
On Wed, 12 Nov 2003 13:27:31 -0600, "Rick Brandt"

Thanks for your reply Rick. Could you point me to where I can
read about how to change my default mdw back to an unsecured
mdw file? Thanks.

I think it depends on your version. In Access 97 and Access 2000 there was
a separate utility program called WRKGADM.EXE. I have Office 97 and Access
2000 installed on my system and it appears that Office 97 installed this in
my System32 folder and Office 2000 installed another copy of it in the
Office folder for Office 2000. In newer versions you might be able to
launch this utility from an Access menu bar.

If you find this utility and run it, it will open a small form. The form
indicates the path to your current default mdw file and provides options
for joining a different mdw file and for creating new ones.
 
On Wed, 12 Nov 2003 16:30:19 -0600, "Rick Brandt"

Thanks again Rick. I guess I should have mentioned
that I'm using XP and Access 2002. I did find the
Workgroup Administration option in Access Security
and pointed back to the System.mdw file, but I'm
still being prompted to logon and nothing seems to
work. I tried Admin with all the passwords I set up in
the test and even a blank password. I also tried all
the test accounts I had set up with their passwords,
still no luck.

I'm thinking I might copy a System.mdw file from a
virgin system that has the same software and OS
that my PC has, and replace the mdw file on my PC.

Lawrence
 
Rick, I don't know if you're still tracking this thread, but
I wanted to thank you again for your help. The last
thing I tried (copying a virgin system.mdw file) worked,
thank goodness. I thought I was going to have to
reformat my harddrive just to get Access working
again.

I totally agree with you that Access security is not
trivial. Looking through the postings on this news-
group, it it obvious many folks struggle with it. I
really think the security wizard is very dangerous.

-------------------------------------------------------------------------


Thanks again Rick. I guess I should have mentioned
that I'm using XP and Access 2002. I did find the
Workgroup Administration option in Access Security
and pointed back to the System.mdw file, but I'm
still being prompted to logon and nothing seems to
work. I tried Admin with all the passwords I set up in
the test and even a blank password. I also tried all
the test accounts I had set up with their passwords,
still no luck.

I'm thinking I might copy a System.mdw file from a
virgin system that has the same software and OS
that my PC has, and replace the mdw file on my PC.

Lawrence
 
Lawrence said:
Rick, I don't know if you're still tracking this thread, but
I wanted to thank you again for your help. The last
thing I tried (copying a virgin system.mdw file) worked,
thank goodness. I thought I was going to have to
reformat my harddrive just to get Access working
again.

I totally agree with you that Access security is not
trivial. Looking through the postings on this news-
group, it it obvious many folks struggle with it. I
really think the security wizard is very dangerous.

Glad you got it worked out.
 
Back
Top