Results 1 to 12 of 12

You don't have the necessary permissions

  1. #1
    registan is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2011
    Posts
    25

    You don't have the necessary permissions

    I wanted to open my DB after using ULS wizard but couldn't.

    It says: You don't have the necessary permissions to use the 'D:\Users\.....\Desktop\Database1.mdb' object. Have your system administrator or the person who created this object establish the appropriate permissions for you.

    Help please...

  2. #2
    registan is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2011
    Posts
    25
    By the way I am using access 2007 but working in .mdb because i need User level security.

  3. #3
    registan is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2011
    Posts
    25
    This is the screenshot of the window.


  4. #4
    registan is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2011
    Posts
    25
    Anyone ???

  5. #5
    CGM3 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Atlanta, GA
    Posts
    49
    This may be a silly question, but do you have read/write permission for that directory (I'm assuming it's on a network or shared drive). Opening an .mdb Access file requires such permission because it has to create and update the associated .ldb file.

  6. #6
    registan is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2011
    Posts
    25
    It's in D: drive.

  7. #7
    CGM3 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Atlanta, GA
    Posts
    49
    Is the D: drive your CD-ROM drive? If so, Access is trying to create the .ldb file on the CD (and failing because you have to burn CDs). Can you copy the database file to your C: drive and connect to it there?

  8. #8
    registan is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2011
    Posts
    25
    No it's not CD-ROM.

    Where ever I put the DB, it's giving me this window. What to do?

  9. #9
    John_G is offline VIP
    Windows XP Access 2003
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    1,014
    The problem is probably with the way you set up the security; you did not set up the permissions correctly for the user name you are try to enter the database with. Try the user "Admin" - if you did not put a password on that user name, or remove the permissions for "Admin", you should be able to open the database and fix the permissions.

    John

  10. #10
    registan is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2011
    Posts
    25
    im sure i did it right. it's not even asking for username.

    i think problem is in .mdw file. how to change it?

  11. #11
    John_G is offline VIP
    Windows XP Access 2003
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    1,014
    If it is not even asking for a user name / password, then a question: are you opening the database just by clicking on the file name? If so, then you are getting the error because MS Access cannot find the .mdw file. Create a shortcut to open the database, so that you can specify the .mdw file location on the command line, in the shortcut target.

    Example:

    "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\MS_Access\QRS_V3\Development\QRS V3 Data.mdb" /wrkgrp "C:\MS_Access\qrs_app.mdw" /user appdev

    Replace the red with the path and name of your .MDW file. /user=appdev intializes the loging dialog with that user name, but there is no requirement to do that.

    Using Windows XP and A2003, I have found that I have to specify the full path to MSACCESS.EXE and put it in quotes; the same for the database name.

  12. #12
    registan is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2011
    Posts
    25
    Yeah worked, thank you very much.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Permissions
    By helpaccess in forum Access
    Replies: 2
    Last Post: 04-22-2011, 02:33 PM
  2. Permissions Issue
    By softspoken in forum Access
    Replies: 2
    Last Post: 04-30-2010, 08:36 AM
  3. Permissions
    By emccalment in forum Forms
    Replies: 12
    Last Post: 02-17-2010, 02:11 PM
  4. Access permissions
    By paulbrog in forum Access
    Replies: 1
    Last Post: 05-05-2009, 10:14 AM
  5. Permissions instruction
    By admaldo in forum Security
    Replies: 0
    Last Post: 05-11-2006, 12:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums