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. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
'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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |