 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / January 2006My user name changed and I can't get into some parts of Access?
Recently our facility Migrated to another Domain. I have to use a different username to get the same access to the Network that I had before. We have an access program that generates Help Desk Request, and when ever I try to go to the privileged area for Network Admins, I get a message that says: "Sorry these utilities are not available to you" I know nothing about access programming someone else wrote it. I just need to make a mod to keep it running Thomas_reneer@nps.gov > Recently our facility Migrated to another Domain. I have to use a > different username to get the same access to the Network that I had [quoted text clipped - 5 lines] > I know nothing about access programming someone else wrote it. I > just need to make a mod to keep it running It seems the applicaton has some sort of authorization scheme based on the network user name. This could have been done in a variety of ways. If original developer hard-coded the authorized user names, only someone who has authority to view and modify the code can make the change. If the developer kept names and permissions in a table, then that table could be modified, although it may require an authorized user to get at it. It's hard to say more without knowing exactly how the authorization scheme was set up. Can someone who is still authorized as an administrator -- as far as that application is concerned -- get into a permissions maintenance function of some sort?  SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) Thanks for the reply Mr. Goldgar, Yes I found the table that you are talking about. Apparently I have access to that table and I was able to change the user name that had been there. I thought that was all that I had to do but as you can see it did not work. I have done a some programming, not in access, and usually when you make a change like that you have to recompile. But I don't see anywhere, that, that can be done. Perminssions maintenance function will try to find where I do that at. > > Recently our facility Migrated to another Domain. I have to use a > > different username to get the same access to the Network that I had [quoted text clipped - 18 lines] > administrator -- as far as that application is concerned -- get into a > permissions maintenance function of some sort? > Thanks for the reply Mr. Goldgar, > Yes I found the table that you are talking about. Apparently I have > access to that table and I was able to change the user name that had > been there. I thought that was all that I had to do but as you can > see it did not work. That's disappointing, though on the bright side, it does imply that the developer did build a somewhat more secure authorization scheme. Did you make sure to enter the user name with exactly the same capital/lower-case letters as the network username you want to authorize? That may or may not make a difference. > I have done a some programming, not in access, and usually when you > make a change like that you have to recompile. But I don't see > anywhere, that, that can be done. I wouldn't expect you to have to recompile after a change to data in a table. > Perminssions maintenance function will try to find where I do that at. At this point, that's your best bet. If I were you, I'd try to get in touch with the person who created the application, or else someone who is now officially responsible for it. SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) OK, I am the one officially responsible for the database now. So I will keep trying. Permissions Function, When I do a search for "Permission" in the help file there are many types. I will have to go through each of them to see what I need to change. > > Thanks for the reply Mr. Goldgar, > > Yes I found the table that you are talking about. Apparently I have [quoted text clipped - 20 lines] > touch with the person who created the application, or else someone who > is now officially responsible for it. > OK, I am the one officially responsible for the database now. > So I will keep trying. > Permissions Function, When I do a search for "Permission" in > the help file there are many types. I will have to go through each > of them to see what I need to change. If you're talking about the Access help file, I don't think what it says about permissions is likely to be relevant in this case, since the authorization scheme appears to to be "home-grown". Unless Access pops up its own login prompt for user name and password when you open the database, I don't think the built-in Access user-level security methods can have been used. From what you said, it's controlling authorization just from the user's network name, and that would have to have been coded by the developer. Do you want to send me a copy of this database, and I'll see if I can get in and figure out the scheme? I may or may not succeed -- it depends on how it was set up. If you want to do that, please compact the database using the ZIP or RAR format and send it to the address you get by removing NO SPAM from the reply-address of this message. If that address isn't visible to you, you can get it from my web site, which is listed in my sig. Do *not* post my real address in the newsgroup -- I don't want to be buried in spam and viruses. SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) I was looking at the screen that shows all the Tables, Forms etc. At the bottom was one called Modules, I clicked that and listed was Module1. I double clicked it and it opened in "Visual Basic Editor". There are 1 or 2 functions described there and one of them was a Function to getusername. Our old Network login names were there and I just changed them. However, to be able to make it work I had to click File-Save entire database- to get the changes to take affect, I could not just close editor and go back to Access. Thanks for all your help. > > OK, I am the one officially responsible for the database now. > > So I will keep trying. [quoted text clipped - 19 lines] > listed in my sig. Do *not* post my real address in the newsgroup -- I > don't want to be buried in spam and viruses. > I was looking at the screen that shows all the Tables, Forms etc. At > the bottom was one called Modules, I clicked that and listed was [quoted text clipped - 5 lines] > could not just close editor and go back to Access. Thanks for all > your help. Great! So you got it all fixed, then. Well done. SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
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.