unknown database owner

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am not an expert or a proffesional in computing, but I am working with
Access and system files from at least 10 years. Along time I was frecquently
in the position to share databases, with end users etc. But I never saw this:
An old database, converted from 97 version to 2000, now to 2003, used at
least once per week, suddently stoped to recognise my as the owner. In fact,
it does not ask for a user name and password anymore.
I want to prevent the standard answer and I am telling you that is the right
system file. What is to do next? The database is rather large, and when I'm
thinking to do it from the scratch...
Sorry for misspelling. That's it. I am not a native...
 
Eugen said:
I am not an expert or a proffesional in computing, but I am working
with Access and system files from at least 10 years. Along time I was
frecquently in the position to share databases, with end users etc.
But I never saw this: An old database, converted from 97 version to
2000, now to 2003, used at least once per week, suddently stoped to
recognise my as the owner. In fact, it does not ask for a user name
and password anymore.
I want to prevent the standard answer and I am telling you that is
the right system file. What is to do next? The database is rather
large, and when I'm thinking to do it from the scratch...
Sorry for misspelling. That's it. I am not a native...
Click to expand...

You are mistaken. If you are not being prompted then either someone has removed
the password from the Admin user on your workgroup file or (more likely) it is
NOT the correct workgroup file. And since you can open the file without logging
in then security was never correct in the first place.

An owner of "unknown" absolutely means that the object was created by an account
that does not exist in the workgroup file currently in use.
 
You should be right. Normally... But... My message intended to be short, but
ended to be confused. There are two different situations. I used, over time,
two different system files, and when I saw that the database does't work, I
tried them both. In the first case, the "owner is unknown" (you described
already the situation), but in the second (the most interesting) is that I
already described: it doesn't ask for password, the access to data is
forbiden, the owner is known (myself), but it will never know, because does
not ask for... I hope this time I was clearer.
 
In the second, it isn't asking for a password because the password has been
cleared for the 'Admin' user. Set a password for this user and you'll get
the login dialog.
 
You are perfectly right, Joan! This episode will remain, for me, at least, an
X-files example, because - Heaven! - I can't remember anything like removing
the password (this is a sick idea...).
Thank you anyway!
 
It is quite easy to accidentally clear the password for the Admin user. It
quite often is listed first in the combobox. If you go in to clear a user's
password, and get quick with the clicking, you hit Clear Password before
choosing the correct user, and clear the Admin password. You can create a
user with 'aa' at the beginning to force this to be listed first and avoid
the problem.
 
Back
Top