Results 1 to 3 of 3

Exporting a form from a split database and create a 2nd front-end db

  1. #1
    ick64 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2017
    Posts
    15

    Post Exporting a form from a split database and create a 2nd front-end db

    Dear all,

    Being quite new to Access (Access 2016 on Win10), I would like to ask you the following:

    1. I created a split dabatase that is running fine: back-end file with tables and front-end file with forms and reports, etc.

    2. I would like to have of the forms (just created, no data yet) at another front-end db as it will be destined to different users

    3. So I would create an empty db file and then:

    a. Export the specific form to that new db
    b. In that new db, connect the back-end db in order to have access to the tables
    c. Delete the form from the previous front-end file


    Will that work? Is it possible to have then 2 or more front-end files pointing to the same back-end db? I am asking before moving on as I do not want to risk damaging the current files.


    Thank you very much!

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,082
    Yes, that is what you are supposed to do anyway for users using same database, multiple FE all linked to the BE database on network.

  3. #3
    ick64 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2017
    Posts
    15
    Great - thank you Bulzie!

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

Similar Threads

  1. Replies: 4
    Last Post: 11-09-2014, 08:56 PM
  2. Replies: 3
    Last Post: 09-27-2013, 06:56 AM
  3. Replies: 1
    Last Post: 04-10-2013, 08:16 AM
  4. Unable to open front end of split database
    By Dunro in forum Import/Export Data
    Replies: 10
    Last Post: 09-17-2011, 06:37 AM
  5. Sending out the front end of a split database
    By Huddle in forum Import/Export Data
    Replies: 3
    Last Post: 07-20-2010, 07:47 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
  •  
Tech Forums: Microsoft Office Forums