Results 1 to 2 of 2
  1. #1
    periphery is offline Novice
    Windows 7 Access 2007
    Join Date
    Jan 2010

    how to update data daily

    i build a database connected to vb6 and want to use it to collect data every day. i made the data by using append query for the list of data and everyday i have to run the append query to update new data to be stored in database.

    the question is how can i stored the data automatically into the database without have to click run the query every day or how can i stored the new data when the date is changing?
    can anyone help me


  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Houston, Texas USA
    You have to directly or indirectly run the query every day.

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

Similar Threads

  1. Replies: 3
    Last Post: 10-30-2013, 11:42 AM
  2. Daily Sign In form
    By JHansford in forum Access
    Replies: 2
    Last Post: 12-09-2009, 08:41 AM
  3. update data base in access
    By freddyraf in forum Access
    Replies: 3
    Last Post: 11-06-2009, 07:01 PM
  4. Creating a Daily Running Total Query
    By seraph in forum Queries
    Replies: 0
    Last Post: 08-15-2009, 12:11 AM
  5. Data Update Problem
    By Nosaj08 in forum Forms
    Replies: 3
    Last Post: 05-15-2009, 02:06 PM

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