Results 1 to 2 of 2
  1. #1
    DMT Dave is offline VIP
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    1,191

    Split Database

    Hi Guy's, If i split a database for multiple users, should i require a new table



    1: I create this in be File ?
    2: Do i need to add the same table to Front end ?

    my front end file wouldn't have a table in to use liked table manager would it ? (because created in be file) ?

    I am going to split one for multiple users but i may need to add more tables at some point..

    Kind Regards

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,974
    1. Yes - assuming its a data table.
    2. No - link to the BE table
    3. The LTM feature doesn't require a separate table
    However, if you choose DSN-less connection strings you would instead have 2 tables in the FE to manage relinking
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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 vicsaccess in forum Access
    Replies: 35
    Last Post: 01-09-2016, 06:24 PM
  3. Replies: 4
    Last Post: 11-27-2013, 09:51 AM
  4. split database on web
    By scoobz1234 in forum Access
    Replies: 1
    Last Post: 05-22-2012, 03:07 AM
  5. Split Database
    By pthoopth in forum Database Design
    Replies: 3
    Last Post: 11-09-2009, 03:37 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