Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query edit (Office 97 & 2003)

    In Sept 2001 we created a Query using MS Excel to MS Access to retrieve data. In Access we had a query that pulled out certain fields that were used to MSExell spreadsheet. Last week we had to relocate the databata from on server t another an now the spreadsheet doesn't work. When I go to the qry to open it up it tells me that the path is not correct and to fix it. Then is pops up a box - Login and it asks for the UserID and password.

    Now body remembers them. So, are we out of luck or is there a way to get in?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Query edit (Office 97 & 2003)

    First. try leaving both empty. If that doesn't work, try Admin as UserID and leave the password blank (empty).

    If neiither work, the database has probably been secured, you'd need to have the secured .mdw file and to know a valid UserID and password to get in.

  3. #3
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query edit (Office 97 & 2003)

    ok, tried admin & blank password - no, tried blank UserID & Password - no. Also, couldn't fine a mdw extension. Does this mean we have to create this from scratch?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Query edit (Office 97 & 2003)

    There might be commercial services that crack the password for you, but I don't have any experience with that. A Google search for microsoft access crack password will probably turn up something.

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query edit (Office 97 & 2003)

    You could try my Query Manager to relocate the database, maybe it works?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •