Results 1 to 6 of 6
  1. #1
    Mattbro is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Mar 2012
    Posts
    92

    How do I Link front end to new linked table in backend


    Hello All,
    I have a database split into backend/frontend. Recently, I have put an excel-linked table in the backend.

    I can't see how to access the linked table data from the front end. I have looked at the linked table manager in the front end, but no success. Can anybody tell me how to do it?
    Many thanks,
    Mattbro

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    21,849
    You would link directly to the Excel file in the front end.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Mattbro is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Mar 2012
    Posts
    92
    Quote Originally Posted by pbaldy View Post
    You would link directly to the Excel file in the front end.
    That sounds.....odd. Don't I want all tables linked to the backend? Users have their own frontend-If I link it to a front end, all users would have to replace their frontends with the my modified version.....

    What if I were to create a new access file, incorporate the linked spreadsheet and create a new split?

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    21,849
    Think about it this way; the Excel file is a different back end. The front end links directly to each, not chained via one of them.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    Mattbro is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Mar 2012
    Posts
    92
    Right you are, Paul-thanks for the gen.

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    21,849
    No problem.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 1
    Last Post: 10-03-2012, 11:15 AM
  2. Replies: 3
    Last Post: 08-06-2012, 10:38 AM
  3. Split DB - Front and Backend
    By sah in forum Access
    Replies: 3
    Last Post: 06-03-2012, 04:21 PM
  4. MS Access Front End MS Excel Backend
    By spideynok in forum Import/Export Data
    Replies: 2
    Last Post: 03-18-2012, 09:15 PM
  5. How to rename a linked table which link to ODBC
    By Connie1122 in forum Database Design
    Replies: 6
    Last Post: 08-02-2010, 02:43 PM

Tags for this Thread

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