update table after every five minutes (1 Viewer)

sahh1419

Registered User.
Local time
Tomorrow, 03:04
Joined
Dec 27, 2012
Messages
29
i am using access database. my requirements is after every 5 minutes it should check the new entry in table and insert it into new table after every 5 minutes only the new entries.
please advised.

Table A
Stuid Number
Intime text
Otime text
Dated date

Table B



Stuid number
msgto varchar2(30)
msg varchar2(300)
send varhar2(1)
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 07:04
Joined
May 7, 2009
Messages
19,169
create a form to your table and add timer event to the form to update the linked oracle table.
 

isladogs

MVP / VIP
Local time
Today, 23:04
Joined
Jan 14, 2017
Messages
18,186
Why are you duplicating data in two tables?
Enter the data in the table you want to store it in.
That should be possible even if its a linked table in an external database as suggested by your datatypes in table B.
 

Users who are viewing this thread

Top Bottom