Link to home
Start Free TrialLog in
Avatar of Richard Korts
Richard KortsFlag for United States of America

asked on

Accessing an Access database

I have a web site I built years ago using classic asp and an Access database.

I need to look into the database to see what is stored in various tables.

I downloaded the DB to my Windows 10 computer & I tried to use Access to open it, I believe it's Access 16.

It asks me for the database password; I have no clue & I can't remember.

So I looked in one of the asp programs that connects to the database. It has the following code

mdbfile = "access_db/mod.mdb"
      connstr = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath(mdbfile ) & ";"
      Set Conn = Server.CreateObject("ADODB.Connection")
      Conn.Open connstr

How can I either determine the password or open the database in Access without knowing the password?

Thanks
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

As per the rules of this site, ...we cannot address questions such as this...
ASKER CERTIFIED SOLUTION
Avatar of Scott Fell
Scott Fell
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Richard Korts

ASKER

To Scott Fell,

I found it. I noticed I had a folder on my local machine called <site name>_pwd. All the connection strings in there have the pwd.

Saved!!
Jeffery, this is not a question about cracking
...From the question, ...this cannot be definitively determined:
How can I either determine the password or open the database in Access without knowing the password?
I downloaded the DB to my Windows 10 computer & I tried to use Access to open it
Could be a legit question, ...could be someone trying to get into a db that should not be...
As outsiders, ...it is hard to tell, as there is no way to authenticate the intentions of the person asking the question.
This has always a grey area.
It's just gets a bit sketchy as to what we should (or should not) say...

...So while I mostly agree on your second point:
"fine to answer except for using non legal cracking options"
...The first point could be debated.

JeffCoachman
Richard,

Don't take my post in the wrong light.
It's just that the rules governing questions like this are not etched in stone...

Jeff
Jeffrey Coachman,

I understand completely; I thought I was out of luck. I know where you are coming from.

Richard