Update table automatically

[Guest]

Hi all,
I have two tables "table1" and "table2". I want to automatically (let's say
every minute) update table2 with the contents of table1.(or delete all the
records of table2 and then insert all the records of table1 to table2).Any
suggestions?

Thanks Kostas

 

[JohnFol]

I'd suggest creating 2 queries, one does a Delete * from Table2, and the
other does Insert Into from table 1. Stick a timer on the form. The timer
simply runs the 2 action queries and handles any UI / Errors etc.

 

[Guest]

The problem is that there isn't in VBA Access the "Timer" control (as in VB)

Kostas

 

[JohnFol]

Agreed, but there is one built into every form by default.

Look at the form properties and look for "Timer Interval" and "On Timer
Event"

 

[John Vinson]

I have two tables "table1" and "table2". I want to automatically (let's say
every minute) update table2 with the contents of table1.(or delete all the
records of table2 and then insert all the records of table1 to table2).Any
suggestions?

I'd suggest you don't let this Form Timer event run for very long!
Access does not recover space when records are deleted; so if there
are more than a few rows in Table2, you'll bloat your database over
the 2 GByte limit very rapidly.

Could you explain *why* you want to do this?

John W. Vinson[MVP]