Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    .mdw file question

    I have a conversation going on with a prior student via email. I am having trouble grasping what might be happening on his end. Do you think you could help me/him out?

    His question:

    I have a database that has student's information in it. I am trying to link a table in that database to mine. However the file they use is a .mdw. From my understanding a mdw isn't a standalone database however if I double click it opens up access with just like a .mdb file would. It isn't a shortcut it's the .mdw, if I rename it to .mdb it still functions the same. I was wondering if you had any insight into what it is.

    My Response:
    MDW files have to be linked to an Access database in order to be effective. MDW is a file extension for a work group file format. It is there because it is used to store information such as usernames and passwords of users authorized to access a secured database. The .mdw file you are trying to open is called a Microsoft Jet database known as the workgroup information file, which is also referred to as the system database.

    The following links may help explain it:

    http://msdn.microsoft.com/en‑us/libr...ffice.10).aspx
    http://www.pcreview.co.uk/forums/lin...;t3935382.html

    His Return Response:
    That clarified some aspects however I ran into the same problem I did while researching by myself. There is no mdb file just a mdw that opens a database. Are they integrated in my case or is something else going on here?

    When I directly open the mdw I do not get any user/pass prompts just opens access. I get a startup form, also I don't know if it helps but when you open the mdw directly, a ldb file is temporarily created in the same location.

    *************
    The only thing I could respond with unless I learn more is: the .mdw is supposed to exist in order to secure login to a database that must exist somewhere...I appreciate any feedback on this.
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    Gold Lounger Roderunner's Avatar
    Join Date
    Dec 2009
    Location
    Scotland.
    Posts
    3,462
    Thanks
    16
    Thanked 216 Times in 183 Posts
    This site might help. Filext
    O wad some Power the giftie gie us, to see oursels as ithers see us!

  3. #3
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts
    You are right about it. The mdw file is used only to control access to an Access .mdb file. Per itself, the mdw file is rather useless.

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thank you

    Quote Originally Posted by ruirib View Post
    You are right about it. The mdw file is used only to control access to an Access .mdb file. Per itself, the mdw file is rather useless.
    As I thought. Thank you however for backing my thoughts up on this.
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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