Results 1 to 3 of 3
  1. #1
    shah1419 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jan 2013
    Posts
    30

    check table update in every five minutes

    i have a table which has 4 fields. i want to check the table in every five minutes is there any data update. i want to show/get the data which is update in time interval 5 minutes only,not whole table data.and then i want to time interval data insert into another table.please advised.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    on a form, set the form property TIMER INTERVAL to 300,000
    Its in milliseconds, so 1 sec = 1000, 5 min= 300000

    in the event ON TIMER,
    put the code to do the check or append
    Code:
    Private Sub Form_Timer()
    docmd.setwarnings false
    If Dcount("*","tData") then docmd.openquery "qaAddMyData"
    
    docmd.setwarnings true
    End Sub
    open the form to start the timer.

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    Having the same data in two tables is generally a mistake in a relational database, unless

    The data acts as a Primary Key/Foreign Key relating two tables together

    The second table is being used in an audit log scheme.

    If the latter is your situation, Allen Browne has an excellent tutorial on the subject:

    http://allenbrowne.com/AppAudit.html

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

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

Similar Threads

  1. Replies: 2
    Last Post: 11-13-2017, 07:23 AM
  2. Replies: 2
    Last Post: 07-23-2015, 07:12 AM
  3. multiple check box values - update table
    By joycesolomon in forum Forms
    Replies: 8
    Last Post: 08-11-2014, 08:02 AM
  4. Replies: 4
    Last Post: 06-12-2013, 10:20 AM
  5. check table, if exist then update another table
    By JeroenMioch in forum Programming
    Replies: 6
    Last Post: 07-06-2012, 09:12 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