Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Simple Q

Discussion in 'Information Technology' started by Michael C, Jul 28, 2006.

Tags:
  1. Michael C

    Michael C
    Expand Collapse
    Guest

    A customer has asked me to import data from a program they are using into
    mine. Writing a custom export is no problem but I can't get into the
    database. It is an mdb file and opening the file in notepad it starts like
    this:

     Standard Jet DB µnb` ÂUé©gr@? o~Yÿ.s1Åyºí0¼ßÌcÙíÇYFûS¼N?ûì

    which confirms I guess that it is an access database. When I try to open it
    in access 2000 it gives me an error saying I don't have permissions. It
    doesn't even ask for a password. Is there some way to confirm what version
    of access this is and is there any way to get past the security?

    Many thanks,
    Michael
     
  2. Loading...

    Similar Threads Forum Date
    Grammer / Vyakarn Learn Simple & Easiest Gurbani Vyakaran/grammer From Prof. Maninderpal Singh Language, Arts & Culture Mar 9, 2015
    General Babaji Ranjit Singh Dhandrian Wale, Simple living high Thinking Hard Talk Sep 27, 2013
    Sikh Weddings Simple? No, they Are Indulged In Brahmanwad Questions and Answers Sep 15, 2012
    The One-Minute Mystic: Simple Things You Can Do to Stay Connected Spiritual Articles May 23, 2011
    Being a Simple Sikh (blog of a Prithihardkaur Sikh) Spiritual Articles Sep 13, 2010

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    You'll need to get the security file (.MDW extension) from your customer.
    Once you have the file, join the workgroup where it is located. Then a
    username and password will let you in.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Michael C" <nospam@nospam.com> wrote in message
    news:%23Fn0zNLmGHA.4864@TK2MSFTNGP04.phx.gbl...
    >A customer has asked me to import data from a program they are using into
    >mine. Writing a custom export is no problem but I can't get into the
    >database. It is an mdb file and opening the file in notepad it starts like
    >this:
    >
    >  Standard Jet DB µnb` ÂUé©gr@? o~Yÿ.s1Åyºí0¼ßÌcÙíÇYFûS¼N?ûì
    >
    > which confirms I guess that it is an access database. When I try to open
    > it in access 2000 it gives me an error saying I don't have permissions. It
    > doesn't even ask for a password. Is there some way to confirm what version
    > of access this is and is there any way to get past the security?
    >
    > Many thanks,
    > Michael
    >
     
  4. Michael C

    Michael C
    Expand Collapse
    Guest

    "Arvin Meyer [MVP]" <a@m.com> wrote in message
    news:ea$dRiMmGHA.4716@TK2MSFTNGP04.phx.gbl...
    > You'll need to get the security file (.MDW extension) from your customer.
    > Once you have the file, join the workgroup where it is located. Then a
    > username and password will let you in.


    Thanks for the reply,

    It comes with an MDA file but no MDW file. Is that just a variation or is
    the MDW stored elsewhere?

    Regards
    Michael
     
  5. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 26 Jun 2006 13:35:52 +1000, "Michael C" <nospam@nospam.com>
    wrote:

    >It comes with an MDA file but no MDW file. Is that just a variation or is
    >the MDW stored elsewhere?


    eeeuwww... that may be a moldy oldie! As I recall, Access 1.0 used MDA
    files, and 2.0 let you choose between MDA and MDW. I'm not certain
    whether newer versions of Access can handle MDA's or not.

    John W. Vinson[MVP]
     
  6. Michael C

    Michael C
    Expand Collapse
    Guest

    "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
    > eeeuwww... that may be a moldy oldie! As I recall, Access 1.0 used MDA
    > files, and 2.0 let you choose between MDA and MDW. I'm not certain
    > whether newer versions of Access can handle MDA's or not.


    hmmm that is quite possible. I've checked the password using this code:

    http://www.trigeminal.com/lang/1033/codes.asp?ItemID=5#5

    and it returns blank but I cannot access it using Admin as username and
    password as blank. Is there something else I should be doing. I've created
    and ODBC datasource and am connecting through that. I've specified the mda
    file as the system database in the ODBC setup which is what they did on the
    users machine. Is there anything else I should be doing?

    Thanks,
    Michael
     
  7. Michael C

    Michael C
    Expand Collapse
    Guest

    "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
    news:71mu92phbq3n35v7t5dstarsp023sok928@4ax.com...
    > On Mon, 26 Jun 2006 13:35:52 +1000, "Michael C" <nospam@nospam.com>
    > wrote:
    >
    >>It comes with an MDA file but no MDW file. Is that just a variation or is
    >>the MDW stored elsewhere?

    >
    > eeeuwww... that may be a moldy oldie! As I recall, Access 1.0 used MDA
    > files, and 2.0 let you choose between MDA and MDW. I'm not certain
    > whether newer versions of Access can handle MDA's or not.


    I've confirmed that it is in fact an access 2.0 database as I had to
    download the access 2 to 2003 converter from MS website. When I open the
    database it now asks for a username and password but how do I get that
    password?

    Thanks again,
    Michael
     
  8. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 26 Jun 2006 16:34:25 +1000, "Michael C" <nospam@nospam.com>
    wrote:

    >how do I get that
    >password?


    From the documentation, or from the original developer.

    The password code you mentioned is for the *DATABASE* password - a
    much weaker protection than the protection provided by a workgroup
    file, even a .mda. The latter can be broken with effort but it's not
    easy.

    John W. Vinson[MVP]
     
  9. Michael C

    Michael C
    Expand Collapse
    Guest

    "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
    > From the documentation, or from the original developer.


    I've asked the customer to request the password from the developer. The data
    does belong to the customer so they should be able to do what they like with
    it but I can see the developer not liking that idea. (I'm not going to gain
    any intellectual property looking at tables and queries :)

    > The password code you mentioned is for the *DATABASE* password - a
    > much weaker protection than the protection provided by a workgroup
    > file, even a .mda. The latter can be broken with effort but it's not
    > easy.


    Is brute force the only option or can those dodgy password revealing
    websites break it?

    Michael
     
  10. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 27 Jun 2006 09:37:19 +1000, "Michael C" <nospam@nospam.com>
    wrote:

    >"John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
    >> From the documentation, or from the original developer.

    >
    >I've asked the customer to request the password from the developer. The data
    >does belong to the customer so they should be able to do what they like with
    >it but I can see the developer not liking that idea. (I'm not going to gain
    >any intellectual property looking at tables and queries :)


    With a properly designed security system, you should be able to get
    the password for a Group which has read (or read/write) access to the
    data in the tables, but no permissions to examine the code.

    >> The password code you mentioned is for the *DATABASE* password - a
    >> much weaker protection than the protection provided by a workgroup
    >> file, even a .mda. The latter can be broken with effort but it's not
    >> easy.

    >
    >Is brute force the only option or can those dodgy password revealing
    >websites break it?


    Brute force will just break the database into little bits... among
    those dodgy websites there are ones that will, and there are
    legitimate sites as well. Those sites' owners would not thank me for
    posting links in this public forum, though.

    John W. Vinson[MVP]
     
  11. Michael C

    Michael C
    Expand Collapse
    Guest

    "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
    news:rkg1a2p26ur4ln39h4v90fguqvrh5fvjbl@4ax.com...
    > Brute force will just break the database into little bits... among
    > those dodgy websites there are ones that will, and there are
    > legitimate sites as well. Those sites' owners would not thank me for
    > posting links in this public forum, though.


    I asked the developer and they sent the password over without question. I
    wasn't expecting it to be that easy. :)

    Michael
     
  12. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 3 Jul 2006 11:13:44 +1000, "Michael C" <nospam@nospam.com>
    wrote:

    >I asked the developer and they sent the password over without question. I
    >wasn't expecting it to be that easy. :)
    >


    Sometimes the simple Q does indeed have a simple A! Good news.

    John W. Vinson[MVP]
     
  13. Michael C

    Michael C
    Expand Collapse
    Guest

    "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
    news:h5bha2pr2rl68i78ua5itgmkngdqolahkd@4ax.com...
    > Sometimes the simple Q does indeed have a simple A! Good news.


    I've been trying to get similar information out of another company for while
    now (with the aim of selling their hardware) with no luck so was assuming a
    similar result. It's interesting to see the different reactions from
    different companies, some simply reply immediately with developer
    information (or just have it as a download) while other's don't even seam to
    know what it is or think you're stealing something from them. :)

    Anyway, thanks for all your help.

    Michael
     

Share This Page