Results 1 to 5 of 5
  1. #1
    jonsuns7 is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2009
    Posts
    9

    Developer Gone Cannot Access Database Structure

    Hi Everyone,



    We have run into a problem for a client's database. The original person who developed the database left a few years back. Unfortunately, it appears that he was the only person who could alter the forms, reports and underlying data. The current end-users can only insert, update and delete data but apparently cannot create or alter forms or reports.

    Is there a way for maybe a Network Admin to override the current privileges? I have worked mainly with UNIX and Oracle and I know of ways to take over ownership but is there a similar thing we could do with Access?

    Or perhaps could we create a copy of the database without the restrictions?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    What version of Access is in use? Is the database "secured" with User Level Security (ULS) or by some other means? Do you have the original file (MDB or ACCDB) or is the user using an MDE?

  3. #3
    Michael is offline Novice
    Windows XP Access 2000
    Join Date
    Feb 2010
    Posts
    1
    Quote Originally Posted by RuralGuy View Post
    What version of Access is in use? Is the database "secured" with User Level Security (ULS) or by some other means? Do you have the original file (MDB or ACCDB) or is the user using an MDE?
    I have since lost the Original Access database before compiling MDE and now not able to make changes to the database forms, reports, modules, etc. I have Access 2000, the tables and the MDE file

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    There are services that can create an MDB from an MDE. Google should be able to find them.

  5. #5
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    If all you have is just the mde, chances are any service you use to try and recover any code will not be able to recover all the code (but you may get things recovered such as the code in modules.) I've never seen any service which can fully recover all the coding from an mde.

    If it's protected via an mdw file (ie. MSAccess security), you can use this to find a login/password with admin privelages.
    http://www.dbforums.com/6426828-post91.html

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

Similar Threads

  1. An import question above the table structure
    By Shag84 in forum Import/Export Data
    Replies: 2
    Last Post: 08-20-2009, 12:21 PM
  2. Replies: 3
    Last Post: 04-27-2009, 02:29 PM
  3. database structure:primary key debate
    By MUKUDU99 in forum Database Design
    Replies: 0
    Last Post: 08-19-2008, 12:20 AM
  4. SQL statment structure
    By oss_ma in forum Programming
    Replies: 1
    Last Post: 05-13-2007, 02:08 AM
  5. Access database synchronizing.. help!
    By mhq04 in forum Database Design
    Replies: 0
    Last Post: 12-12-2005, 03:28 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