Results 1 to 10 of 10
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    UK
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access security files MDW (97)

    What is the Access 2000 equivalent of an Access 97 MDW file? Is it the same or is there a new arrangement for security in Access 2000?

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access security files MDW (97)

    A2K can use A97 MDW files. Security is basically the same except that workgroup security no longer applies to modules.

  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Location
    UK
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access security files MDW (97)

    OK, now for my next question!

    I never bothered upgrading from Access 2.0 .MDA files and I would like to upgrade to .MDW - do you know of a utility that will do this?

    Will .MDA files work with Access 2000?

  4. #4
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Access security files MDW (97)

    Generally you can use workgroup files created in an earlier version of Access with A2K, but I would not recommend doing so. There is no utility that I know of that will convert an archaic .MDA workgroup file to an A2K .MDW file. In addition, MS advises against converting workgroup files directly. MSKB Article Q282357 ACC2002: Error Messages When You Convert Workgroup Information (.mdw) File to Access 2002 states in part:
    <hr> You should not convert workgroup information files by using the Convert Database utilities in Access. There are two reasons for this: First, there have been security improvements in Microsoft Jet 4.0 workgroup information files, and to take advantage of these improvements, you must re-create the workgroup information file.

    Second, even though workgroup information files are standard Jet database files, they do not contain an Access project storage for forms, reports, macros, and modules. When Access attempts to convert the file, it generates error messages because it cannot locate the Access project storage for these objects.<hr>
    IVO above I would be leery of any "utility" that claimed it could successfully convert a .MDA file to a .MDW. When converting secured applications, the Microsoft Access Security FAQ recommends recreating workgroup file in latest version of Access; de-securing application in older version of Access before converting; then re-secure app in current version using new workgroup file. See the FAQ for full details. In converting several A97 apps to A2K this approach proved most reliable. The A2K User-Level Security Wizard will do a lot of the work for you. Also recommend installing the A2K Security Manager Add-in, download from:

    ACC2000: Microsoft Access Security Manager Add-In Available in Download Center

    Some other MSKB articles that may be of interest:

    ACC2000: Understanding the Role of Workgroup Information Files in Access Security

    ACC2000: Overview of How to Secure a Microsoft Access Database

    HTH

  5. #5
    Star Lounger
    Join Date
    Feb 2001
    Location
    UK
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access security files MDW (97)

    Thanks - that's a pretty comprehensive reply!

    My only snag is finding the Workgroup ID information which I put in a safe place a few years ago...

  6. #6
    Star Lounger
    Join Date
    Feb 2001
    Location
    UK
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access security files MDW (97)

    I am a little confused about one thing - if I recreate my .MDA Workgroup file as an Access 2000 .MDW file, using the original Workgroup ID and re-create all the users using the Personal IDs, will my upgarded databases then automatically assign the correct permissions to all users once the workgroup is pointing to the databases?

    What I mean is, does that mean I won't have to go through each database re-assigning permissions to all users?

    Thanks

  7. #7
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Access security files MDW (97)

    No, you won't have to reassign permissions, as long as you keep the same UserID. The permissions information is stored in each database - the MDW/MDA files only store information about users and groups and the security ID info.
    Wendell

  8. #8
    Star Lounger
    Join Date
    Feb 2001
    Location
    UK
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access security files MDW (97)

    So could I simply rename my .MDA file extension to .MDW and it would still work? That could be an interim step while I upgrade from Access 97 to Access 2000, and then I could re-create the .MDW file using Access 2000 wrkgadm.exe

  9. #9
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Access security files MDW (97)

    I don't think you have to rename the extension - I believe Access 2000 can still work with an MDA file - at least give it a whirl. As a suggestion in terms of setting up workgroup files - we usually use a rememberable security ID so if we need to recreate a file we can. One strategy is to make it the same as the UserID. Another is to use a set of numbers that are easily reproducible. And you should be able to make an MDW file in either Access97 or Access2K.
    Wendell

  10. #10
    Star Lounger
    Join Date
    Feb 2001
    Location
    UK
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access security files MDW (97)

    Thanks for the advice - when creating users I make the ID the same. I probably had a very rememberable Workgroup ID when I created it 5 years ago but I have since forgotten it and the file with the information saved has been archived ...somewhere!

    Thanks

Posting Permissions

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