Results 1 to 5 of 5
  1. #1
    JFo is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    393

    Problems accessing database and removing Permissions

    I have an old access 2003 database that I would like to clean-up/ repair or create a new database and import all tables/ queries/ data/ etc however I cannot gain access or administer permissions.



    I have tried virtually everything from trying to import into a new database to changing all user access permissions using both access 2003 and access 2010.

    I have been through many pages in google and nothing seems to work as I get error messages no matter what I change and it will not allow me to change owner as it states I must login as administrator but I can't find out how?

    The database is owned/ created by Engine however it just logs me in every time as Admin and I can't change anything even after I create a new Workgroup Administrator or join the current one it doesn't change from Engine as owner.

    Furthermore if I try and import it says I don't have permission either and must speak to administrator, so I have no idea how to become an administrator or login as one if I can't change anything or access the database if I am not an administrator which is quite frustrating

    The complete back-end consists of 2 x mdb files one of which is an audit file and 1 x .mdw file and I can access the audit.mdb and the .mdw files however the main database .mdb will not let me in no matter what I do and states errors such as

    'You do not have the necessary permissions to use MDB objects...Have your system administrator or the person who created this object establish the appropriate permissions for you. ''.


    Any ideas and help are appreciated?

    Thanks

  2. #2
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Just a quick reply for now. Busy at the moment.

    To create a New Database with no permissions do the following.

    Create a New Blank Database. Let’s call it “FRED”

    Open FRED using the Security associate with the Target Database. This includes the MDW Reference.

    You should now be able to import all Objects from the original DB.

    Close FRED then reopen without security. If successful you should have a new Unsecured Database.
    Last edited by Rainlover; 12-14-2011 at 02:30 AM.

  3. #3
    JFo is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    393
    Thanks Rain that seems simple enough however I already created another workgroup and joined that and now when I join the original workgroup it is asking me for a user name and password to get into both .mdb files and the .mdw file which I have never had to enter before as I was previously automatically logged in as Admin. It even will not allow me to create a new database without this UN/ PW combo?

    Thanks

  4. #4
    JFo is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    393
    Issue resolved

    Thanks

  5. #5
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Happy to hear good news for a change.

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

Similar Threads

  1. Problems accessing a split database
    By tobydobo in forum Access
    Replies: 51
    Last Post: 09-24-2012, 08:49 PM
  2. Permissions for sharing a database
    By Nixx1401 in forum Security
    Replies: 1
    Last Post: 12-12-2011, 10:10 PM
  3. Removing all carriage returns from a database
    By Yesideez in forum Access
    Replies: 2
    Last Post: 06-26-2011, 09:55 AM
  4. removing security from not my own database
    By zomas in forum Security
    Replies: 1
    Last Post: 08-01-2010, 10:43 PM
  5. Problems with run permissions on a query
    By admaldo in forum Queries
    Replies: 0
    Last Post: 05-09-2006, 09:04 AM

Posting Permissions

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