Results 1 to 4 of 4
  1. #1
    cmul is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    4

    updating an imported table

    I have imported a table from one access database to another. The data is there and everything is fine. However when i add data to the first (original) database it doesn't automatically update into the imported (second) database. Is it possible to do this. (I know that i can link the table however this doesn't allow me to do what i need to do) Updating the imported table is the preffered option if i can do it.



    thanks
    cmul

  2. #2
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    U need to update the table using an Update Query.

  3. #3
    cmul is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    4
    Have tried. Am struggling to get it working.
    thanks
    cmul

  4. #4
    cmul is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    4
    Sorry if i am on the wrong track here. I think what i need is an Append query to refresh or update my records in the second or imported table.

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

Similar Threads

  1. Auto updating table
    By forrestapi in forum Forms
    Replies: 1
    Last Post: 08-16-2010, 11:06 AM
  2. Linking Access Table with already imported External Data (Excel)
    By izzarshah in forum Import/Export Data
    Replies: 1
    Last Post: 07-29-2010, 09:40 AM
  3. Table not updating (Anyone Please Help)
    By goyal_cyber in forum Queries
    Replies: 7
    Last Post: 05-28-2010, 09:42 AM
  4. updating a table from a form.....
    By softspoken in forum Access
    Replies: 7
    Last Post: 04-21-2010, 09:04 AM
  5. Updating a table from a form
    By Lynn in forum Forms
    Replies: 3
    Last Post: 03-18-2010, 10:51 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