 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Security / November 2004Permissions problem
I am the owner/administrator/user of a mdb file. I must have boobed but I wanted to change the security of the macros in that particular file so that it would open always without prompting. Now I cannot open the file at all. I get the error message "You do not have permission to open this object file. Get the owner or administrator to change the permissions to enable you to open the file" - or words to that effect. Hope you can assist. Arthur, You need to log on to your database as a member of the Admins group so you can change the security settings that you implemented.  SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm > I am the owner/administrator/user of a mdb file. I must have boobed but I > wanted to change the security of the macros in that particular file so that > it would open always without prompting. Now I cannot open the file at all. > I get the error message "You do not have permission to open this object file. > Get the owner or administrator to change the permissions to enable you to > open the file" - or words to that effect. Hope you can assist. Hi Lynn: I wasn't sure how to do as you requested. But I did create another workgroup file and the only change from the original path is it added a "1" to the original path. Can I go back to the initial workgroup? Basically how does one log on to a database as a member of a Admins group? Tx for your kind assistance to date Lynn. Art > Arthur, > You need to log on to your database as a member of the Admins group so you [quoted text clipped - 9 lines] > > Get the owner or administrator to change the permissions to enable you to > > open the file" - or words to that effect. Hope you can assist. Yes, you can use the Workgroup administrator to join the original workgroup file. SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm > Hi Lynn: > [quoted text clipped - 20 lines] > > > Get the owner or administrator to change the permissions to enable you to > > > open the file" - or words to that effect. Hope you can assist. Lynn: Sorry Lynn - but the question still remains - how do I find out how to log on to the admin group? I still cannot open my own file! Tx Art > Yes, you can use the Workgroup administrator to join the original workgroup > file. [quoted text clipped - 29 lines] > you to > > > > open the file" - or words to that effect. Hope you can assist. When you set up security, did you create a new user and add that user to the Admins group? Are you getting a username/password prompt when you open the database? SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm > Lynn: > [quoted text clipped - 38 lines] > > you to > > > > > open the file" - or words to that effect. Hope you can assist. Hi Lynn: Sorry to keep bothering you - but I have two rather big databases; one of which I did add another user to the group - not sure if it is admin or not; and to your second question - no I do not get a username/password prompt. I am still locked out. > When you set up security, did you create a new user and add that user to the > Admins group? Are you getting a username/password prompt when you open the [quoted text clipped - 50 lines] > > > you to > > > > > > open the file" - or words to that effect. Hope you can assist. Arthur, That suggests that you probably removed the Admin user from the Admins group without creating a new user AND without setting the Admin user's password. Let me suggest that you try joining the default system.mdw file that ships with access. SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm > Hi Lynn: > [quoted text clipped - 57 lines] > > > > you to > > > > > > > open the file" - or words to that effect. Hope you can assist. Hi Lynn: Seems that I have opened the proverbial "kettle of worms"! I probably would now need basic 1 to whatever steps it takes to do as you suggested. How do I specifically do what you suggest "try joining the default system.mdw file that ships with access. By the way I have upgraded to Access 2003. Is this an inherent problem with this version? Tx for your ongoing help and sorry for the "headaches" I am probably causing. Arthur > Arthur, > That suggests that you probably removed the Admin user from the Admins group [quoted text clipped - 73 lines] > > > > > > > > open the file" - or words to that effect. Hope you can > assist. > How do I > specifically do what you suggest "try joining the default system.mdw file > that ships with access. First, you need to locate that file. Do a search for system.mdw on your computer. Once you locate it, then you need to open Access without opening a database. Go to Tools > Security > Workgroup Administrator. Follow the instructions for joining the workgroup that you searched for. > By the way I have upgraded to Access 2003. Is this > an inherent problem with this version? No, it's not a problem with the version, but it is evidence that the 2003 wizard does what it is supposed to do better than previous versions have. SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Lynn: Having followed your instructions - the file now asks me for a Logon name (defaults to Amin) and a password. Things that I never set! The saga continues. Art > > How do I > > specifically do what you suggest "try joining the default system.mdw file [quoted text clipped - 10 lines] > No, it's not a problem with the version, but it is evidence that the 2003 > wizard does what it is supposed to do better than previous versions have. Well, Someone, perhaps inadvertently, has gave the Admin user for that system.mdw file a password. Now that you are joined to that workgroup file, close access and delete that system.mdw file. When you reopen access, it should create a new one for you. SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm > Lynn: > [quoted text clipped - 18 lines] > > No, it's not a problem with the version, but it is evidence that the 2003 > > wizard does what it is supposed to do better than previous versions have. Hi Lynn: I did what you suggested. Closed access, searched for system.mdw, deleted it and reopened Access. One of my files opens ok, but the smaller database now only asks me for a password (no logon name)! Are we getting somewhere with this yet? It is really infuriating. Art > Well, > Someone, perhaps inadvertently, has gave the Admin user for that system.mdw [quoted text clipped - 28 lines] > > > wizard does what it is supposed to do better than previous versions > have. ----- Original Message ----- From: "Arthur" <Arthur@discussions.microsoft.com> Newsgroups: microsoft.public.access.security Sent: Thursday, November 25, 2004 5:41 AM Subject: Re: Permissions problem > Hi Lynn: > > I did what you suggested. Closed access, searched for system.mdw, deleted > it and reopened Access. One of my files opens ok, but the smaller database > now only asks me for a password (no logon name)! Are we getting somewhere > with this yet? It is really infuriating. That is a different issue; the simple file-password feature. Do a Google search as the file password is very simple to hack and there are several web sites that describe how. If you don't remember ever assigning a file password then you could be screwed as prompting for a password when one was never assigned is also a symptom of file corruption, usually a type that cannot be repaired. SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com Lynn: Looks like you have foresaken me. I did receive a note from a Rick Brandt - no legible signature but a garbled sign-off on hunter dot com! You might like to look at his message. The problem is NOT different as he says. I do think this is a problem that microsoft should look at. I would love to hear your comments. I have never issued a password to any of my access files, nor do I think the file is corrupted! Art > Well, > Someone, perhaps inadvertently, has gave the Admin user for that system.mdw [quoted text clipped - 28 lines] > > > wizard does what it is supposed to do better than previous versions > have. > Lynn: > [quoted text clipped - 4 lines] > your comments. I have never issued a password to any of my access files, nor > do I think the file is corrupted! This part is very simple. There are two kinds of security prompts that Access can issue. One associated with User-Level Security that asks for a UserName AND a Password. The other associated with a file level password that ONLY asks for a password. On the file in question you have indicated the latter. There are two ways that can cause an Access file to prompt you for a file-level password. Either someone has applied a password to the file or it is corrupted. So your file is either corrupted or someone else has put a password on it. SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com Arthur, No, I didn't forsake you. I just left work at my usual time. Take a look at Rick Brandt's messages about a database password that has apparently been set or, else, is being prompted for because of some kind of corruption. SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm > Lynn: > [quoted text clipped - 39 lines] > > > > wizard does what it is supposed to do better than previous versions > > have. Lynn: Rick's messages do not solve any problems - they seem just to add to them! He sounds very condescending, and perhaps a little aloof. I am seeking help not criticism. I did not set a password, I am the only one who uses this database. I am not sure what, if any, chances there are of ever retrieving a lot of hard work here. It would appear from the other threads, that I am not the only one who has encountered this problem. You say the security system for this access version is fine, if set up properly. This is what several of us want to know. If you can set up security one way - we should be able to unset it as well. It does not seem to be the case here. Art > Arthur, > No, I didn't forsake you. I just left work at my usual time. Take a look at [quoted text clipped - 54 lines] > > > > > wizard does what it is supposed to do better than previous versions > > > have. > Rick's messages do not solve any problems - they seem just to add to them! > He sounds very condescending, and perhaps a little aloof. I am seeking help > not criticism. I never have, and do not now, see anything condescending in Rick's tone. I think he is a very helpful person. You should take a look once more at what he has to say, if you are only receiving a password prompt and not a username/password prompt. > I did not set a password, I am the only one who uses this > database. I am not sure what, if any, chances there are of ever retrieving a > lot of hard work here. Since you indicated that, with one of your databases, you were prompted for a password without a logon name then that is an indication of a database password. Either somebody had to set it or, else, the file has become corrupted. Are you now able to open any of your databases without a username/password prompt? SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Lynn: I have re-looked at Rick's notes and tried everything and thought of everything he has suggested. Nothing is working. As a last resort I have had to rebuild from an old .bak file. This is really not the way this situation should be resolved; but I am at a loss how to rectify the original problem. Now if you can tell me how to change a database file named "family.bak" to family.mdb I would be very appreciative. Art > > Rick's messages do not solve any problems - they seem just to add to them! > > He sounds very condescending, and perhaps a little aloof. I am seeking [quoted text clipped - 18 lines] > Are you now able to open any of your databases without a username/password > prompt? Right click on the file in windows explorer and change the .bak extension to .mdb. SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm > Lynn: > [quoted text clipped - 29 lines] > > Are you now able to open any of your databases without a username/password > > prompt? Hi Lynn: I run XP Pro and it does not allow the change to any extension as you suggest. I had to go to DOS and use the rename command. Tx for your aid, but I still suggest that a more simplified security system should be installed within this version of Access. Art > Right click on the file in windows explorer and change the .bak extension to > ..mdb. [quoted text clipped - 39 lines] > username/password > > > prompt? > I run XP Pro and it does not allow the change to any extension as you > suggest. I had to go to DOS and use the rename command. That's kind of odd. Does it actually not "allow the change" or does it warn you that it might cause problems? I change extensions on XP all the time. > Tx for your aid, > but I still suggest that a more simplified security system should be > installed within this version of Access. A more simplified security system would most likely not work at all. Security is never an easy thing on any system. I'm sure there is some step that you have missed but can't figure out what it is from your description. SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Hi Lynn: I opened Windows Explorer, found my file "sample". I right clicked on the file name; but all I could change was the name. The "bak" extension was over to the far right; and out of touch. I did not get both the file name and extension together to change just the extension. I have my explorer view set to details? In consequence of your reply about the security system, of course you are right, it's just the instructions for making any changes are "scary". I just wanted to have my macros open automatically. All my access database files are my own - and not to be an egoist - I do trust myself. I always appreciate your help - especially to the renaming possibility. The files asking me for a password are now "history" and all have been renamed and rebuilt to the current status. But if I have the wrong settings set for windows explorer I would like to know about it. Thanks in advance Lynn. Art > > I run XP Pro and it does not allow the change to any extension as you > > suggest. I had to go to DOS and use the rename command. [quoted text clipped - 9 lines] > Security is never an easy thing on any system. I'm sure there is some step > that you have missed but can't figure out what it is from your description. > But if > I have the wrong settings set for windows explorer I would like to > know about it. Thanks in advance Lynn. Tools, Folder Options, View tab. You'll see the option to hide extensions is checked -- uncheck it. SignatureJoan Wild Microsoft Access MVP > to details? In consequence of your reply about the security system, of > course you are right, it's just the instructions for making any changes are > "scary". I just wanted to have my macros open automatically. There is a reason that we recommend, over and over again, to read the secuity FAQ several times before you ever start trying to secure a database. And, then, only do it on a copy of the database, so you can scrap it if anything goes wrong. Nearly everyone who has been successful in implementing Access security, including myself, Joan Wild, and Doug Steele, will tell you that it took us several tries on a test system before we got it right. SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Arthur... Access2002 Mdb is Access2000 I have the exact same problem I have a backend mdb file that has been in use for some time. I opened the security menu to investigate. Now all users, including me, get the same error message that Arthur has described.. I have never had to deal with 'workgroup' or 'user' permissions in the current Novell environment. The database has never had passwords nor permissions set. I am effectively locked out of my own database. This is despite me having created the mdb and being the admin. This is an urgent problem. Whilst I have a backup from earlier in the day, users have updated the backend since then and if I drop back to that version, data will be lost. > I am the owner/administrator/user of a mdb file. I must have boobed but I > wanted to change the security of the macros in that particular file so that > it would open always without prompting. Now I cannot open the file at all. > I get the error message "You do not have permission to open this object file. > Get the owner or administrator to change the permissions to enable you to > open the file" - or words to that effect. Hope you can assist. > I opened the security menu to investigate. > Now all users, including me, get the same error message that Arthur has > described When you "opened the security menu to investigate" just what did you do? Did you run the security wizard? Did you create a new workgroup? Did you create any new users? Are you getting a logon prompt. SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm > Arthur... > Access2002 [quoted text clipped - 27 lines] > > Get the owner or administrator to change the permissions to enable you to > > open the file" - or words to that effect. Hope you can assist. I to am experiencing this ... and urgently need back in. I was trying to stop the security warnings from coming up and I ran the sequrity wizard accidentally and had a prompt for a user name and canceled it (as I had never had to enter before)... now I get the "don't have access. contact administrator) and it lists me as the administrator and I can't access... > > I opened the security menu to investigate. > > Now all users, including me, get the same error message that Arthur has [quoted text clipped - 37 lines] > to > > > open the file" - or words to that effect. Hope you can assist. Jenn, Try logging in with a blank password. SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm > I to am experiencing this ... and urgently need back in. > I was trying to stop the security warnings from coming up and I ran the [quoted text clipped - 44 lines] > > to > > > > open the file" - or words to that effect. Hope you can assist. Thanks Lynn... I basically did not "do" anything. I ran the security wizard to investigate whether this was implicated in some unusual record locking. I have never run it before. I did not create anything but cancelled out at the first oportunity. I did not create a workgroup nor users. There is no login prompt. All I get is the "You do not have permission to open [name of mdb file] file. Get the owner or administrator to change the permissions to enable you to open the file" As I am the owner and administrator of the database, I find the message particularly irksome. This appears to be an 'open manhole cover' with no warning signs or safety net as several other posters have the same experience. > > I opened the security menu to investigate. > > Now all users, including me, get the same error message that Arthur has [quoted text clipped - 37 lines] > to > > > open the file" - or words to that effect. Hope you can assist. What version of Access are you using? The first think I would try, Geoff, is to make sure that you are joined to the system.mdw file that ships with access. SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm > Thanks Lynn... > [quoted text clipped - 64 lines] > > to > > > > open the file" - or words to that effect. Hope you can assist. Lynn As described in the intial post... Access 2002 using an access 2000 level database. As described in the intial post, I have never needed to familiarise myself with the permissions structure of Access. What exactly do you mean by "join to the system.mdw file that ships with access"? What do you mean by "you" are joined? > What version of Access are you using? The first think I would try, Geoff, > is to make sure that you are joined to the system.mdw file that ships with [quoted text clipped - 73 lines] > > > to > > > > > open the file" - or words to that effect. Hope you can assist. Geoff, When you run Access there has to be a .mdw file that authenticates users -- even if Admin is the only user. When you run the security wizard it creates a new .mdw file -- usually called secure.mdw. You may have gotten yourself into this situation by being joined to that new group and, somehow, having no valid users who can access the database with that group. Thus, if you rejoin the original system.mdw file this may fix your problem. SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm > Lynn > As described in the intial post... [quoted text clipped - 91 lines] > > > > to > > > > > > open the file" - or words to that effect. Hope you can assist. Lynn... I have attempted to join every .mwd file that exists in the environment in which I have been working. Nothing has changed the behaviour on trying to load my database. It is an unbelievably stupid security system that entraps the user without warning. This has caused me as administrator a great deal of time and my users have lost half a day's work. > Geoff, > When you run Access there has to be a .mdw file that authenticates users -- [quoted text clipped - 60 lines] > > > > create > > > > > any new users? Are you getting a logon prompt. news:41a33553$0$25783$5a62ac22@per-qv1-newsreader-01.iinet.net.au... > > > > > > Arthur... > > > > > > Access2002 [quoted text clipped - 44 lines] > > > > > to > > > > > > > open the file" - or words to that effect. Hope you can assist. Geoff, Without sitting and actually looking at your setup, I don't know what else I can offer at this point. Access Security is a fine tool, when setup and used properly. SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm > Lynn... > [quoted text clipped - 131 lines] > > > > > > > > open the file" - or words to that effect. Hope you can > assist. Hi Geoff: Hope that either you, myself or Jenn finally get to the bottom of this problem. I will watch the ongoing saga with intense interest. Arthur > Thanks Lynn... > [quoted text clipped - 64 lines] > > to > > > > open the file" - or words to that effect. Hope you can assist. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.