Access 2003 Password

Hi all,

The original file was something other thank Access 2003, but the computer is now operating the 2003 version.  

Anyway, I need to get into a backend that has been secured.  The person that did the securing doesn't know the password anymore...so...  

I have access to the data, as this is just the backend, and the tables are linked to my frontend.  The password is not a user level password, but rather the startup password.  I tried some of the VBA solutions on here for Jet 3.0 or 3.5, and they returned incorrect strings, as was confirmed by creating a new database with a known password to test with.

I suppose if it comes down to it I will just copy the tables from the frontend into a new database, and start over, but that is a pain, and time consuming.  All this just so I can add a primary key onto a table that should already have one!

G  

PS> If there is any way to add that primary key without opening the backend database, that will suffice.  High points due to difficulty and urgency.
LVL 1
graysocAsked:
Who is Participating?
 
infolurkConnect With a Mentor Commented:
If the frontend database is connecting to the backend automatically, the username and password will be in the connection string. Have a look for that.
Once you have grabbed the un and pw from the connection string you should be able to login to the backend.

Cheers
Steve
0
 
Raynard7Commented:
Hi,

I do not know about the password issue - but you should be able to run the query

ALTER TABLE "Products" ADD PRIMARY KEY("ProductID");

where your table is called Products and the key field is "ProductID" (you can add multiple fields for the key after the brackets)
0
 
graysocAuthor Commented:
Ah, I thought you had it man..

"Cannot execute data definition statements on linked data sources"

Any other ideas?

G
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
Rey Obrero (Capricorn1)Commented:
<Cannot execute data definition statements on linked data sources>

you have to open the backend db

Set db = OpenDatabase(BEPath)
db.Execute "ALTER TABLE TableName ADD PRIMARY KEY FIELDNAME"
Set db = Nothing
0
 
infolurkCommented:
Unless they specify a read only connection....
0
 
graysocAuthor Commented:
infolurk, that was exactly what I needed to know.  Thank you.

G
0
 
infolurkCommented:
No worries.

Steve
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.