Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Security Damaged by Office Repair Utility?

    This morning I did a 'detect and repair' using the menu item of the same name in Outlook. After it was completed
    the logon box in Access (I have deployed User level security which created a Workgroup Information file) no longer appears and I can't access my data in the databases which have been secured. Non-secured databases are still accessible. I'm not sure why. It would seem that the program is no longer searching in the right Windows folder for the Workgroup Information file "Security.mdw" . How can correct operation be restored? Has anyone heard of this before?

  2. #2
    DaveShmave
    Guest

    Re: Access Security Damaged by Office Repair Utility?

    Hi David,

    I'm sure you've tried these, but in an effort to cover all the bases I'll ask a few questions.

    1. Do you have a backup copy of the 'Security.mdw' file?

    2. And is/was the name of your MDW file something other than 'system.mdw'?

    3. It obviously sounds like your security file is hosed. Does it still exist, that is, the 'Security.mdw' file?

    If you happened to have a recent backup of the file in question, you should be able to get back into business fairly soon.

    If not, post back and someone else will have the solution. Maybe even me.

    HTH

    Dave <img src=/S/smash.gif border=0 alt=smash width=30 height=26>

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Security Damaged by Office Repair Utility?

    Thanks for your help but in desperation I forced myself to reread the section on securing Access Databases in the Microsoft VBA Programmers guide to discover that the registry is where the information is located that tells Access where to find secured.mdw or any other WIF.
    Here's the key:
    HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice9.0Access Jet4.0Engines
    I edited it to say what it said before I applied the "fix" and all is well again. Hope this information is useful to someone else too!

  4. #4
    DaveShmave
    Guest

    Re: Access Security Damaged by Office Repair Utility?

    Actually I didn't realize that, so it was certainly useful information for me.

    Thanks and glad you're up and running again.

    Dave <img src=/S/smash.gif border=0 alt=smash width=30 height=26>

Posting Permissions

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