HELP! I forgot the db password

[Guest]

I created an excellent inventory db using ACCESS 97 (that is how old it was),
it was upgraded (converted to ACCESS 2000) but when I made my last back up
copy, it was May 2002.
Since then, I have continued to learn ACCESS development and someone asked
to see previous work of mine. When I tried to open my old DB, it asked the
password and I can not for my life, remember what it was.
Is there any hope? Anyone who I can send my db to and you can get past it
and send it back to me.
There is enough of my info in the db to show i designed it.

HELP! Please.
Robert

 

[Larry Linson]

I created an excellent inventory db using ACCESS 97 (that is how old it
was),
it was upgraded (converted to ACCESS 2000) but when I made my last back up
copy, it was May 2002.
Since then, I have continued to learn ACCESS development and someone asked
to see previous work of mine. When I tried to open my old DB, it asked
the
password and I can not for my life, remember what it was.
Is there any hope? Anyone who I can send my db to and you can get past it
and send it back to me.
There is enough of my info in the db to show i designed it.

If it is an overall database password, and you still have a copy of the
Access 97 version, you'll find a password retrieval example/sample at
http://www.trigeminal.com. He wrote it because it was so trivial and he was
tired of seeing people get ripped off for 40 or 50 dollars by people selling
the same functionality.

Googling archived posts in comp.databases.ms-access might give you some
things to try short of purchasing software to break security -- Serge
Gavrilov used to have a free password recovery db at
http://accesstools.narod.ru that also demonstrated it could be done on a
much more detailed scale (that is, the user and group level security). It,
too, as I recall was for A97, and, if memory serves, it was the last one he
bothered to do, because there wasn't much market for those.

But I understand others still create and sell similar software. That's why
we don't suggest you rely on Access security if the contents of your
database are valuable. You can use any of a number of server databases, with
an Access front-end, and have heavy-duty security. (Yes, I know, even
'password lite' can seem heavy-duty if you can't get into your own
database.)

Larry Linson
Microsoft Access MVP

 

[Guest]

Larry, I visited the site, but could only find the password retrieval for a
Jet 3x database and I have no idea what that is. I did not find the link for
the ACCESS password retreival. Could you be more specific in the link? or
tell me how to do it?

Robert

 

[Guest]

Larry, the link to narod.ru was most helpful. Thank you very much. Now i
just need to find out what is a Jet 3x or 4 db.

Have a great day.
RT

 

[Douglas J. Steele]

Access 97 used Jet 3.5x. Access 2000 (and newer) use Jet 4

BTW, the specific link at MichKa's site is
http://www.trigeminal.com/codes.asp?ItemID=5#5 As Larry stated, if you've
got an overall database password in Access 97, that will retrieve it for
you.