Results 1 to 3 of 3
  1. #1
    ROCKET01 is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2011
    Posts
    1

    Moving Access Objects Between Databases

    I have developed a secure database called 'ILT System.mdb' for the ILT Team using the default workgroup information file Routeways.Mdw. However this default WIF is also the main security file for another team (Employment).



    What I want to do is to create a new WIF Called ILTSystem.MDW which contains only users of the ILT TEAM. I create the file and join it to the ILTSystem.mdb but when I do, I come up against the "don't have the necessary permissions to use this database" message.

    Any Ideas of how to get around it, If I create a new database file with the ILT System.mdw it allows it, but once I try to import the objects from the ILT System.mdb I get the "don't have the necessary permissions to use this database" message again.

    Any ideas.

  2. #2
    apr pillai's Avatar
    apr pillai is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2010
    Location
    Alappuzha, India
    Posts
    209
    First of all we will explore the easiest solution for this.

    1. If you have Administrative Rights (or if you are the Ower of this database, i.e. you have created this database under your UserID within this WIF) in the Routeways.mdw file then create a separate Workgroup Account (say ILTTEAM) for ILT Team in this WIF. You can create more Group Accounts this way for the ILT Team, if required.
    2. Assign object-wise (Tables, Forms, Report, Macros) permissons to the ILTTEAM Group Account.
    3. Add individual ILT Team User Accounts to this Group Account.
    4. If any of the ILT Team member is part of any other Group Account then remove them from that group, except Users Group.



    Microsoft Access Security Token have several pieces of informations put together and we can call them security key elements. You can see these infornation in the form of a Key from here: Microsoft Access Security Key Diagram.


    1. Workgroup Information File's internal Name, Organization Name, Unique ID - these three information must be saved somewhere if you want to recreate the WIF.
    2. Each User will have User Name, Personal ID & Password (Grooup Account will have only Group Name and Personal ID).



    These six elements of the Security Token are only kept in the WIF. Individual Objects (Tables, Form etc.) Access Right informations (Read, Write, Modify, Delete etc.) are kept within the individual database itself. When User's information from WIF and Access Rights information from the database fits together then you will get access to the database and it's individual objects, otherwise you will not.

    I hope, now you know why you didn't get access to the database when you have joined a different Workground Information File. When you create a separate Workgroup Information for your database you are expected to provide the Routeways.mdw file's internal Name, Organization Name & Unique ID information, which you doesn't have with you.

    Read more on Microsoft Access Security from here.

  3. #3
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    AP's advice is first rate. I do feel obligated to add the point that you should keep in mind that you are developing in a 10 year old version of the application. This workgroup security was abandoned by Microsoft in the .accdb format beginning with Access 2007. ... fyi.

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

Similar Threads

  1. Replies: 5
    Last Post: 12-06-2010, 09:29 AM
  2. moving tables between databases
    By TheShabz in forum Programming
    Replies: 4
    Last Post: 11-15-2010, 05:54 PM
  3. All Access Objects shows nothing
    By Viwadd in forum Access
    Replies: 5
    Last Post: 05-29-2009, 02:23 PM
  4. Moving Records Between Databases
    By sscott in forum Access
    Replies: 2
    Last Post: 03-22-2009, 09:08 PM
  5. Replies: 2
    Last Post: 01-14-2008, 12:15 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
  •  
Other Forums: Microsoft Office Forums