Results 1 to 9 of 9
  1. #1
    Join Date
    Jun 2008
    Posts
    163

    Unanswered: separating tables and forms

    What is the most efficient way of re-setting my forms to recognize tables in a different mdb?

    I made my db with all my forms, queries and tables in a single file. I was wondering if I could move all my tables to a different mdb, then have them accessed as linked tables (or something like that, I haven't tried it). Will I have to manually edit all codes in my forms? or are there alternatives? thanks! =D

    Btw, should the queries go to the file with tables or the file with forms?

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    What you're describing is a "split database." This is the normal way a multi-user database is configured. Forms, queries, reports and such reside in the front end, and the data in tables resides in the back end. One copy of the the back end usually resides on a shared server, and a copy of the front end is placed of each user's PC.

    Access has a tool that will do the splitting for you, automatically.Go to

    Tools - Database Utilities - Database Splitter.

    It's probably a good idea to make a backup copy of your database befpre splitting it, as well as doing a Compilation of the code to check for errors.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yup, just use the Database Splitter

    No recoding necessary. The queries stay in the front end.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Jun 2008
    Posts
    163
    Thanks guys! I'll try it later. =D

  5. #5
    Join Date
    Jun 2008
    Posts
    163
    Works like a charm. You hit it on the head with "multiuser db". I'm planning to put this on a small network, how do I set the mdb file to find the linked tables over a network?

    I intend to copy the front end mdb to a couple of clients. =D

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    It's pretty easy, but there are a few alternatives.

    I suggest that you put both the front end and back end on a shared network path and then use the Linked Table Manager (Tools - Database Utilities) in the FE to link the tables to the BE.

    You can then use PK's VBS file launcher (pretty sure that's in the code bank) from each client machine to open the FE for each user. You can also just have users open the FE directly, but there are some disadvantages to that.

    Make sure you keep backups!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  7. #7
    Join Date
    Sep 2007
    Location
    Global Village
    Posts
    185
    I think you should find a book and find all these simple questions there and ask only questions which is hard to find answers in books and old posts here, I mean splitting database is one of the simple basics mentioned in all books regarding MS Access.
    Star is a nice member of this forum and also very professional as well as some other members, I suggest you ask professional questions here and find simple questions in learning books.
    Cheers
    <<Never Walk on the Traveled Path, Because it only Leads you to where the Others have been.>>
    Graham Bell

  8. #8
    Join Date
    Jun 2008
    Posts
    163
    @ST:

    Aight! I think I already downloaded pk's file launcher (or at least one of his other apps), I'll give it a look and learn what I can.

  9. #9
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Give it a go! I needed some convincing that it was the right way to go but now I have experienced it, I won't be going back to what I was doing previously.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •