cannot change password

R

Richard

Hi

I tried to change my password for my logon. I get a message saying that the
db is read only and will not be able to change.

Why is it so when I am the "owner" of the database with admin rights?

Thanks in advance

Richard
 
6

'69 Camaro

Hi, Richard.

Either you've unintentionally opened the database file in read-only mode
(such as from a Windows shortcut), or your Windows user account has only
"Read" security permissions on the database file or workgroup information
file, or the database file attribute or workgroup information file attribute
is set to "Read-only." Find out which of these circumstances is affecting
your database and change it.

Then, if this database has user-level security applied, log into it to
change your password. If this database has shared-level security applied,
open the database exclusively to change the password.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
R

Richard

Hi Gunny

Thanks for taking time to reply. The file is not on read only mode and I
have administrator rights on the folder etc.

The database has user-level security and I am using the front-end to logon
and change my password or add users to the database. I can't seem to to both
task. I think will be able to do the tasks if I open exclusively ie all
other users will need get out... which is not what i'm looking for.

How do I go about it?

Thanks again in advance

Richard
 
6

'69 Camaro

Hi, Richard.
The file is not on read only mode and I
have administrator rights on the folder etc.
Click to expand...

Check all _three_ files, the front end, the back end, and the workgroup
information file, to ensure the following:

1.) The file's "Read-only" attribute is not checked.
2.) The directories containing each of these files has security permissions
set to "Full Control" for your user account.
3.) The file security is set to "Full Control" for your user account.
4.) The file security is set to "Inherit from parent the permission entries
that apply to child objects" if you're using Windows XP or "Allow
inheritable permissions from parent to propagate to this object" if you're
using Windows 2K.
5.) The file name of the workgroup information file does not match the
database file name if these files are located in the same directory. For
example, MyDB.mdb and MyDB.mdw should not be stored in the same directory,
because they'll both use the same locking database file.

Also, ensure that the database file is opened without a Windows shortcut
while you are troubleshooting the problem.
I think will be able to do the tasks if I open exclusively ie all
other users will need get out
Click to expand...

User-level security does not require one to have exclusive access to the
database to change a user's password or to add a new user. One can open the
database in shared mode.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
R

Richard

Hi Gunny

I did what you suggested but the error still persist. I asked all users to
close and then I logon again and changed the password - no problem. I then
asked the users to log back on and tried again - no do.

What am I missing?

Thanks again

Richard
 
D

Damien McBain

'69 Camaro said:
5.) The file name of the workgroup information file does not match
the database file name if these files are located in the same
directory. For example, MyDB.mdb and MyDB.mdw should not be stored
in the same directory, because they'll both use the same locking
database file.
Click to expand...

Answers one of my unasked questions! If they are, how can I move the mdw
without screwing things up?
 
D

Damien McBain

Richard said:
Hi Gunny

I did what you suggested but the error still persist. I asked all
users to close and then I logon again and changed the password - no
problem. I then asked the users to log back on and tried again - no
do.

What am I missing?
Click to expand...

#5 in the previous post if the symptoms suggest that your problem is the
same as mine ie the database name (in my case, FACTS.mdb) is the same as the
workgroup file name (FACTS.mdw) and they're in the same directory.
 
6

'69 Camaro

Hi, Richard.

You keep mentioning that you are using user-level security and need to
change _your_ logon password. Let's step back for a second.

Are you using both user-level security _and_ shared-level security? When
you successfully changed your password, did you use the "User and Group
Accounts" dialog window to change your user logon password, or did you use
the "Set Database Password" dialog window to change the database password?

The shared-level security (database password) will always need exclusive
access to the database file to set and unset the database password.
However, the user-level security does not need exclusive access to the
database file to set and unset any user's logon password or to add new users
to the workgroup.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
6

'69 Camaro

Hi, Damien.
how can I move the mdw
without screwing things up?
Click to expand...

This locking database file problem comes into play whenever a user needs to
log into the database in exclusive mode. You need to decide whether making
this change is worth the pain involved. Personally, I'd go with the pain
now to keep from increasing the pain later as more users get added to the
workgroup.

If you decide to make the change, then you'll need to communicate with your
users immediately so that you can make this change with the smallest snafu.

You have the choice to change the name of the MDW file or change the
location of the current MDW file to another network shared directory. Then
you'll create a Windows shortcut to open the secured database with the new
name or new location of the MDW file.

The next step depends upon how your users are currently opening the
database. If your users have a shortcut (which includes the current MDW
file) to the database on their desktops, then you'll need to distribute the
new shortcut to your users and have them replace their old one <yikes!>. If
the users are joined to the workgroup from the current MDW file, then
they'll all need to join the default Access workgroup (System.MDW) <groan!>,
then you'll need to distribute the new shortcut to your users and have them
replace their old one <yikes!>. If your users aren't currently using a
shortcut, then they certainly will after you distribute the new shortcut.

Don't expect this to go smoothly. Murphy was an optimist, you know. ;-)

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
R

Richard

Hi Gunny

I don't use a database password and yes, i used the "User and Group
Accounts" dialog window to change my user logon password.

I did some changes to the file directory about the full control setting.
This morning, the database now allows only one user... If another user tries
ot log on, a dialog box comes up saying " Could not use "admin"; the file is
already in use".

What should I do now?

Thakns again

Richard
 
R

Richard

Hi Gunny

It seems that all has returned to normal.... I am able change the password
and add users.... I think I should have asked all the users to logout and
login to the server after I changed the settings of the directory.

Anyway, thanks a million for your time, advice and the help to overcome the
issue.

Richard
 
6

'69 Camaro

Hi, Richard.
It seems that all has returned to normal.... I am able change the password
and add users
Click to expand...

That's good news!
I think I should have asked all the users to logout and
login to the server after I changed the settings of the directory.
Click to expand...

Yes. But after re-reading all of the earlier messages, I realize that I
_didn't_ mention that all users in a multiuser Access database must have
"Full Control" security permissions on the directory to prevent users from
interfering with each other when logging into the database, due to the
locking database file that is also located in the same directory as the
database file. I mention this so many times per week that I assumed that I
had also mentioned it to you, too. Sorry about that. I think that at least
one of your database users was blocking you from opening the database
because that user did not have "Full Control" security permissions on the
directory, even though you did.
Anyway, thanks a million for your time, advice and the help to overcome the
issue.
Click to expand...

You're welcome!

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
O

Ole A.Andersen

Richard said:
Hi Gunny

I don't use a database password and yes, i used the "User and Group
Accounts" dialog window to change my user logon password.

I did some changes to the file directory about the full control setting.
This morning, the database now allows only one user... If another user
tries
ot log on, a dialog box comes up saying " Could not use "admin"; the file
is
already in use".

What should I do now?

Thakns again

Richard


in
message news:[email protected]...
Click to expand...
 
Top