password will not work

  • Thread starter Thread starter Dean
  • Start date Start date
D

Dean

we have a database that is used by many people it is
secured a when a user opens it a form/switchboard comes up
and they can do various things such as enter vaction. To
see all the tables queries reports etc we have use a
funtion button and a password. Out of the blue the the
function button opens password screen but will not let
you "in" password has not changed was working went back
in later and would not work.....help please!!!

Thanks
Dean
 
we have a database that is used by many people it is
secured a when a user opens it a form/switchboard comes up
and they can do various things such as enter vaction. To
see all the tables queries reports etc we have use a
funtion button and a password. Out of the blue the the
function button opens password screen but will not let
you "in" password has not changed was working went back
in later and would not work.....help please!!!
Click to expand...

This is apparently not a database that has been secured using Access user-level
security (that would require providing a username and password before the
database actually opens) and the functionality you describe must have been
"home-spun", so, unless we know what the code is behind the button on the
"password" form that performs the validation of the password there is no way for
anyone to know why the code isn't working. If the password is stored in a table
(which would be appropriate, but not necessarily in the same database file) then
it is possible that it *has* been changed or, possibly, corrupted. Check that
first and, if all seems okay there, post a copy of the pertinent code so that we
can at least see if something in the code might be contributing to your problem.
 
To initially get into database yes it asks for username
and password you then see a main menu from here you can
enter in data do a few reports but if you hit a f11
another password prompt comes up and then you can get to
all tables queries reports etc and modify all objects. I
don't think this db was secured properly because it does
not convert properly to 2k (it is a 97 db) but it was
secured via user level security. This has done this same
thing one other time but it let me in fter awhile out of
the blue. This was working one minute and i went back in
20 minutes later and nothing when i do F11 it gives me my
menus file view etc.. but it will not let me see my tables
queries etc.....I can get to them this way: i copied db
did what i just described and went to tools/security and
gave user group all rights made a blank datbase exported
it over and got to the tables i needed. This is a real
pain...so if you know why my db is doing this please let
me know.


Thanks
 
To initially get into database yes it asks for username
and password you then see a main menu from here you can
enter in data do a few reports but if you hit a f11
another password prompt comes up and then you can get to
all tables queries reports etc and modify all objects.
Click to expand...

I see. That first prompt for username/password would be the only one related to
Access user-level security. It appears that there is an "AutoKeys" macro that
has redefined what the F11 key does - it normally opens the database window - so
that you now get that "password" form, instead. We would still need to see the
code from that "password" form that validates the password; without it one could
only guess what is taking place.
I
don't think this db was secured properly because it does
not convert properly to 2k (it is a 97 db) but it was
secured via user level security.
Click to expand...

Couldn't tell you whether the database was secured properly. The conversion
difficulty is likely another issue.
This has done this same
thing one other time but it let me in fter awhile out of
the blue. This was working one minute and i went back in
20 minutes later and nothing when i do F11 it gives me my
menus file view etc.. but it will not let me see my tables
queries etc.....I can get to them this way: i copied db
did what i just described and went to tools/security and
gave user group all rights made a blank datbase exported
it over and got to the tables i needed. This is a real
pain...so if you know why my db is doing this please let
me know.
Click to expand...

Does each user have a copy of the application file on their own workstation or
is everyone opening the same MDB?

I recommend the following web resources that might help you deal with some of
your issues:

Splitting your Microsoft Access MDB into a front end and back end
http://www.granite.ab.ca/access/splitapp.htm

Microsoft Access Security FAQ Available in Download Center
http://support.microsoft.com/default.aspx?kbid=207793
 
Back
Top