Results 1 to 3 of 3
  1. #1
    jmccon is offline Novice
    Windows 10 Access 2007
    Join Date
    Oct 2015
    Posts
    12

    Splitting 2007 Access DB

    I am trying to split an access 2007 DB into a front and back end.


    Anyone know of any resources on how to do this?

    Thanks.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    in the db, tools, Access database. (yeah, bad labeling)
    it will ask you to name the backend.

    (2007 may have SPLIT, its been a while)

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    It is pretty easy to do it yourself. (I always do).


    OK, a BE (back end) has only tables in it. A FE has everything EXCEPT tables.
    The FE (front end) gets linked to the BE.



    Lets say your dB is named "DealerData.accdb".
    First, make 2 COPIES of you dB. Most important, move one copy somewhere safe.
    Second, rename 1 of the remaining copies to "DealerData_BE.accdb". Rename the other database to "DealerData_FE.accdb".

    Open the BE and delete all objects that are not tables. That means delete all Queries, Forms, Reports, and Modules. Also Macros if you use them (I don't). Close and save the database.
    Open the FE and delete ALL Tables. Close and save the database.


    Now to link the tables:
    Open the FE dB. In the menu click on "External Data". In the "Import & Link" Group, click on "Access".

    Follow the prompts to select the BE database ("DealerData_BE.accdb") and be sure to select the radio button to LINK to the tables.
    Then select all of the tables you want to link to the FE (should select ALL tables). Click OK and you should be done. (I use A2010 so things might be a little different in A2007).
    All linked tables will have an arrow to the left of the name.

    TADA!!!




    If multiple people are going to use the database, EACH user should have a COPY of the FE on their local computer. DO NOT create a shortcut that everyone used to open the database.
    That is a sure way to corrupt your dB. Not a maybe, just a when will it happen!!





    Good luck with your project.....

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

Similar Threads

  1. Replies: 8
    Last Post: 01-29-2020, 01:45 PM
  2. Replies: 5
    Last Post: 06-05-2015, 10:00 AM
  3. Replies: 1
    Last Post: 02-04-2013, 05:52 PM
  4. Export Table in Access 2007 to Multiple Workbooks in Excel 2007
    By hutchinsm in forum Import/Export Data
    Replies: 5
    Last Post: 03-01-2012, 05:23 PM
  5. Replies: 2
    Last Post: 06-18-2011, 09:55 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