Results 1 to 3 of 3
  1. #1
    winterh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    110

    How do i link a new table to my frontend database

    Sorry to be a little stupid, I have made a new table and query within my backend database how do I share the table and query with the frontend of the database.



    I think I must be missing somthing very simply but just cant see it.

    Cheers

    Hads

  2. #2
    mejia.j88 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Nov 2011
    Location
    california
    Posts
    228
    Under the tab External Data, the Import section, click Access.
    Second option links tables.
    In the front end of the database, create a new query based on the imported table.
    I'm not sure if you can import queries.

  3. #3
    winterh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    110
    Thanks a lot, was looking at it and could not see it, just for information it does not do query

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

Similar Threads

  1. Link SQL Database to new Access front end
    By gumbi17 in forum SQL Server
    Replies: 3
    Last Post: 02-07-2012, 10:07 PM
  2. Replies: 2
    Last Post: 12-20-2011, 07:33 AM
  3. Replies: 1
    Last Post: 11-25-2011, 11:16 AM
  4. Replies: 2
    Last Post: 08-01-2011, 11:35 PM
  5. 2 SQL Database sources one frontend
    By kevinharding in forum Programming
    Replies: 3
    Last Post: 03-22-2006, 06:34 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