[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Access 2003 Password

Posted on 2006-10-19
7
Medium Priority
?
255 Views
Last Modified: 2008-01-09
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.
0
Comment
Question by:graysoc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 35

Expert Comment

by:Raynard7
ID: 17770160
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
 
LVL 1

Author Comment

by:graysoc
ID: 17770189
Ah, I thought you had it man..

"Cannot execute data definition statements on linked data sources"

Any other ideas?

G
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 17770231
<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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
LVL 8

Accepted Solution

by:
infolurk earned 2000 total points
ID: 17770809
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
 
LVL 8

Expert Comment

by:infolurk
ID: 17770814
Unless they specify a read only connection....
0
 
LVL 1

Author Comment

by:graysoc
ID: 17773259
infolurk, that was exactly what I needed to know.  Thank you.

G
0
 
LVL 8

Expert Comment

by:infolurk
ID: 17785683
No worries.

Steve
0

Featured Post

What’s Wrong with Your Cloud Strategy ?

Even as many CIOs are embracing a cloud-first strategy, the reality is that moving to the cloud is a lengthy process and the end-state is likely to be a blend of multiple clouds—public and private. Learn why multicloud solutions matter in this webinar by Nimble Storage.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question