Results 1 to 5 of 5
  1. #1
    NickCarroll is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Sep 2017
    Posts
    8

    When and How to SPLIT a database

    I'm 100% convinced on the merits of splitting databases: I want my tables to reside on a network drive and users to access the info via a front-end which resides in their 'private' drive on the same server.
    The question is how/when to split the database.



    1. I know that I could create the database locally (initially) and have it contain all the tables, queries, forms, etc., and then use the SPLIT TOOL to move the tables to a back-end location.
    2. Alternatively, I know I can create the accdb file at the server location where the tables are going to reside and then, once that's finished, create a new accdb file at the local drive and simply link to the tables in the other file on the server. I can then create all the queries and forms I need here.


    Is the net result of 1 and 2 the same?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    i find it best to build tables and queries and everything all in one.
    Once you get it working and no more table design is needed, split it.
    Its a pain to alter tables when they are in 1 db, and code is in the other. (but it will always need tweeking)
    But yes, once you have it working, split, then deploy the FE to the others.

  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
    Is the net result of 1 and 2 the same?
    Yep. Ends up with a BE of just tables and a FE with all other objects (except the tables).

  4. #4
    NickCarroll is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Sep 2017
    Posts
    8
    Thanks Ranman, appreciate your comments.

  5. #5
    NickCarroll is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Sep 2017
    Posts
    8
    Thank you ssanfu. Much appreciated.

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

Similar Threads

  1. Replies: 3
    Last Post: 08-01-2017, 01:14 PM
  2. Split Database
    By injanib in forum Access
    Replies: 4
    Last Post: 10-27-2014, 02:47 PM
  3. Replies: 4
    Last Post: 11-27-2013, 09:51 AM
  4. Split database
    By survivo01 in forum Database Design
    Replies: 4
    Last Post: 08-02-2013, 03:53 PM
  5. Split database
    By accessnewb in forum Access
    Replies: 4
    Last Post: 08-12-2011, 08:45 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