Automatic Refresh of data from ODBC Database Every 5 Seconds

[kuihnpd11]

I have an Access Database set up that is linked to 2 tables in a much larger SQL Server Database through ODBC. The setup is very simple. I have 2 queries and I run 2 reports off of them. I need these reports to refresh every 5 seconds and include the new data. These reports are updated from the query tabs so there are no forms involved, the data is simply updated by our users in the datasheet views for each of the queries. I will be projecting these reports onto the TVs in our suite so that is why I need this automatic updating capability for the reports. Is there any way to set something up to have the reports automatically refresh/regenerate every 5 seconds?

Thanks

[twinnyfo]

Set the timer interval to 5000

In the OnTimer Event:

Me.Requery

That should about do it....

[Rabbit]

You can use the Timer event of the report to requery the report.

[NeoPa]

How about you play with the settings in the Options | Advanced screen. You get there from :
2003 & previous - Tools | Options | Advanced
2007 & subsequent - File | Options | Client Settings (Scroll to near the bottom).

As the default value for ODBC refresh interval (sec) is 1,500 I suspect great care and consideration should be given before setting it too low. Have a play and see what works for you in your own specific scenario.

[kuihnpd11]

Thanks for the help!