Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jul 2002
    Location
    Petersburg, Virginia
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unexpected permissions error (Access XP/SR2)

    I use a desktop shortcut on a Windows 2000 system to access the zzz database. The database is located on a server; several users access the database also. The shortcut reads: "C:Program FilesMicrosoft OfficeOffice10MSACCESS.EXE" "xxxyyyzzz.mdb" /wrkgrp "xxxyyyzz.mdw". As the developer I have set permissions for user-level security. Yesterday all was well; today I (and others) are getting this error message:

    You do not have the necessary permission to use the

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

    Re: Unexpected permissions error (Access XP/SR2)

    Perhaps the .mdw file has become corrupt, or even the .mdb file. Do you have recent backups of both?

  3. #3
    Star Lounger
    Join Date
    Jul 2002
    Location
    Petersburg, Virginia
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unexpected permissions error (Access XP/SR2)

    I have a recent backup of MDB file, no backup of MDW file

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

    Re: Unexpected permissions error (Access XP/SR2)

    Make a copy of the backup, then create a shortcut that opens this copy with the secured mdw file. If this works ok, the problem was with the database. If it doesn't, you may have to recreate the mdw file from scratch.

  5. #5
    Star Lounger
    Join Date
    Jul 2002
    Location
    Petersburg, Virginia
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unexpected permissions error (Access XP/SR2)

    Copy of database works. 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
  •