Richard Korts
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 .Connectio n")
Conn.Open connstr
How can I either determine the password or open the database in Access without knowing the password?
Thanks
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
Conn.Open connstr
How can I either determine the password or open the database in Access without knowing the password?
Thanks
As per the rules of this site, ...we cannot address questions such as this...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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!!
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 itCould 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
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
ASKER
Jeffrey Coachman,
I understand completely; I thought I was out of luck. I know where you are coming from.
Richard
I understand completely; I thought I was out of luck. I know where you are coming from.
Richard