My user name changed and I can't get into some parts of Access?

[Guest]

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

(e-mail address removed)

 

[Dirk Goldgar]

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

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?

 

[Guest]

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.

 

[Dirk Goldgar]

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.

 

[Guest]

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.

 

[Dirk Goldgar]

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.

 

[Guest]

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.

 

[Dirk Goldgar]

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.

Great! So you got it all fixed, then. Well done.