Refresh ODBC data

[MNJoe]

I have several reports that connect through an ODBC connection. I run the
reports then check for errors and bring it to the attention of the apropriate
person to fix. when I come back and run the report again it comes up with the
same data. How do I refresh the data from the ODBC everytime the report is
run.

Thanks

 

[MNJoe]

Just some more info. I am importing the tables and not linking them, Why,
These reports are usually only run, at most once everyday by the users. This
brings up a couple of new questions. If more than one user runs the report
does it import the new data for each user. How often does it refresh the data
when it is run. Should I be linking the tables instead of importing? Please
if someone can shead some light on this it would be greatly appreciated.

Thanks

 

[Rick Brandt]

Just some more info. I am importing the tables and not linking them,
Why, These reports are usually only run, at most once everyday by the
users. This brings up a couple of new questions. If more than one
user runs the report does it import the new data for each user. How
often does it refresh the data when it is run. Should I be linking
the tables instead of importing? Please if someone can shead some
light on this it would be greatly appreciated.

Importing rather than linking makes sense in some circumstances, but if you
want the data refreshed every time you run the report then importing no
longer makes sense and you should be linking instead.