Database Backend Data password

[Roy via AccessMonster.com]

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

 

[Douglas J. Steele]

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.

 

['69 Camaro]

Hi, Roy.

I've use Debug.Print StPasswordOfStDatabase("C:\xData.mdb")
with a lot of success.

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.

But there is one database that I ran which revealed the following

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.

Does anyone know how I can get around this?

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.