We are conducting migrating our Access97 & Access2000 databases to Access2003.
In doing so a lot of the backend Access databases have a database password
prompt.    I've use    Debug.Print StPasswordOfStDatabase("C:\xData.mdb")
with a lot of success. 

But there is one database that I ran which revealed the following :      ›•l
When I type this in, it still says that the password is wrong.  It looks like
symbols instead of a password. 

Does anyone know how I can get around this?  I can enter the frontend okay,
it's only the backend data database.

Thanks,
Roy

To the best of my knowledge, StPasswordOfStDatabase isn't a built-in
function in Access, so it must be something you're written or found.

news:7a3b3be6b09db@uwe...

Show quote

Hide quote

Hi, Roy.

MichKa's code will only reveal the database password on Jet 3.0 and 3.5
databases.  It won't show the database password on Jet 4.0 databases, which
is what Access 2000 and 2003 are.

Running MichKa's code on a Jet 4.0 database reveals garbage.  What's
revealed can't be used as if it were the password, because it isn't.

Contact the database developer and ask him to give you the passwords to
those files.  He's responsible for them and is required to give them to
someone in authority in the organization when he leaves.  If he forgot, then
he'll be happy to provide you with that information if you are, indeed,
authorized to have it.  Otherwise, have that someone in authority contact
him to get the passwords.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

Access 2007 user level security (lack thereof)
Why can't I delete a user?
cannot clear password with 2003 or 2007
folder security nightmare to allow .ldb file deletion
Permission should be permission, right?!?!