Results 1 to 5 of 5

Removing Security form 2003 Database

  1. #1
    schmidtbb is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    3

    Removing Security form 2003 Database

    I used Access 2003 to create a database and use the MDW feature to secure it.

    Since them, the company has update MS Office to 2007. I am trying to conver the database to accdb.

    1) I enable the MDW feature in 2007 so that I can get into 2003 database.
    2) I try and use the conversion tool but I get the following error. "You attampted to open a database that is already opened exclusivly by username (which is me)"

    I tried to remove the security feature but if I change to the standard MDW I cannot open the 2003 database.

    Any suggestions?

    -schmidtbb
    Attached Thumbnails Attached Thumbnails conversion.JPG  

  2. #2
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    28,080
    Did you try import into new Access 2007 project?
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  3. #3
    schmidtbb is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    3
    I did try and import the database into 2007. I get the follwoing error. "You do not have the proper permission. Have your system administrator or the person who created this object establish the appropriate permission for you"

  4. #4
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    28,080
    You no longer have Access 2003 available?

    I have never protected a project to this degree, never used mdw. I don't know if there are any work arounds.
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  5. #5
    schmidtbb is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    3
    Ok thanks. Hopefully someone else can help me.

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

Similar Threads

  1. Replies: 0
    Last Post: 12-29-2011, 03:21 PM
  2. ms access 2003 split security?
    By alex_raju in forum Access
    Replies: 1
    Last Post: 07-18-2011, 03:35 AM
  3. Access 2003 Workgroup Security recovery
    By Malisaw in forum Access
    Replies: 1
    Last Post: 07-12-2011, 10:55 AM
  4. removing security from not my own database
    By zomas in forum Security
    Replies: 1
    Last Post: 08-01-2010, 09:43 PM
  5. 2003 Security in 2010
    By tgavin in forum Security
    Replies: 0
    Last Post: 07-29-2010, 09:00 AM

Tags for this Thread

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