A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

cannot change password



 
 
Thread Tools Display Modes
  #1  
Old September 15th, 2004, 02:30 AM
Richard
external usenet poster
 
Posts: n/a
Default cannot change password

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


  #2  
Old September 15th, 2004, 04:40 AM
'69 Camaro
external usenet poster
 
Posts: n/a
Default

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.)


"Richard" wrote in message
...
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




  #3  
Old September 15th, 2004, 08:31 AM
Richard
external usenet poster
 
Posts: n/a
Default

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
"'69 Camaro" AM wrote in
message ...
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.)


"Richard" wrote in message
...
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






  #4  
Old September 15th, 2004, 09:05 AM
'69 Camaro
external usenet poster
 
Posts: n/a
Default

Hi, Richard.

The file is not on read only mode and I
have administrator rights on the folder etc.


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


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.)


"Richard" wrote in message
...
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
"'69 Camaro" AM wrote

in
message ...
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.)


"Richard" wrote in message
...
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








  #5  
Old September 15th, 2004, 10:27 AM
Richard
external usenet poster
 
Posts: n/a
Default

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
"'69 Camaro" AM wrote in
message ...
Hi, Richard.

The file is not on read only mode and I
have administrator rights on the folder etc.


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


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.)


"Richard" wrote in message
...
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
"'69 Camaro" AM wrote

in
message ...
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.)


"Richard" wrote in message
...
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  
Old September 15th, 2004, 10:27 AM
Damien McBain
external usenet poster
 
Posts: n/a
Default

'69 Camaro wrote:

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.


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


  #7  
Old September 15th, 2004, 10:30 AM
Damien McBain
external usenet poster
 
Posts: n/a
Default

Richard wrote:
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?


#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.


  #8  
Old September 15th, 2004, 10:43 AM
Richard
external usenet poster
 
Posts: n/a
Default

Hi Damien

My mdw file is in another directory

Richard

"Damien McBain" wrote in message
...
Richard wrote:
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?


#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.




  #9  
Old September 15th, 2004, 10:49 AM
'69 Camaro
external usenet poster
 
Posts: n/a
Default

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.)


"Richard" wrote in message
...
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
"'69 Camaro" AM wrote

in
message ...
Hi, Richard.

The file is not on read only mode and I
have administrator rights on the folder etc.


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


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.)


"Richard" wrote in message
...
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
"'69 Camaro" AM

wrote
in
message ...
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.)


"Richard" wrote in message
...
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












  #10  
Old September 15th, 2004, 11:26 AM
'69 Camaro
external usenet poster
 
Posts: n/a
Default

Hi, Damien.

how can I move the mdw
without screwing things up?


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.)


"Damien McBain" wrote in message
...
'69 Camaro wrote:

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.


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




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook Password Problem Alistair General Discussion 3 September 6th, 2004 08:53 AM
outlook 2003 losing password when xp pro password changed mike General Discussion 1 August 2nd, 2004 09:33 PM
Outlook 2000 never asks for my password - why?? Thomas Marti General Discussion 0 July 14th, 2004 10:55 AM
XP Pro password change, changes outlook 2003 password mike General Discussion 0 July 12th, 2004 03:47 PM


All times are GMT +1. The time now is 10:58 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.