Results 1 to 3 of 3
  1. #1
    Toasty is offline Novice
    Windows Vista Access 2007
    Join Date
    Jun 2014
    Location
    The Netherlands
    Posts
    18

    Adding data to an external linked table


    Hello,

    I am using a lot of ODBC links in my database that provides the base of my database. Also I have a link to a table that provides dealer data. I have to make notes for each dealer and I have to be able to check or uncheck the dealers. Ofcourse I have to make these notes local and can not change the linked table itself. I don't want to because I want to have the most up to date data.

    What are my options?

    Regards,

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    I don't know what you mean by 'check or uncheck the dealers' but even if all of your tables are linked from ODBC sources you can create a local table that will track what you want and build your forms/queries around the data in that table.

    So for instance if you have a unique dealer ID your local table would have a FK (foreign key) corresponding to the dealer ID, a primary key of it's own (autonumber is just fine) and whatever fields you want to track for that dealer, for instance the date of the note, the note itself etc.

  3. #3
    Toasty is offline Novice
    Windows Vista Access 2007
    Join Date
    Jun 2014
    Location
    The Netherlands
    Posts
    18
    I fixed with an other solution. With check and uncheck I only meanth that I want to be able to use the manual checkbox. I now have made both an append and update query that I use to update my local table. That works fine.

    Thanks though for answering!

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

Similar Threads

  1. Adding data from linked table to existing table???
    By claysea in forum Import/Export Data
    Replies: 3
    Last Post: 02-21-2013, 12:23 PM
  2. Creating a table with local and external data
    By Accessnoooob in forum Access
    Replies: 8
    Last Post: 06-25-2011, 07:36 PM
  3. Replies: 5
    Last Post: 11-28-2010, 03:55 PM
  4. populate table w/ external data
    By tlittell in forum Programming
    Replies: 2
    Last Post: 02-20-2010, 08:29 AM
  5. Replies: 2
    Last Post: 10-27-2009, 07:09 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