Refreshing Data in Report?

[kelvin24]

i have a ODBC connected to Pervasive database. I created some reports that retrieved data from the database. I dont know if it is possible to refresh the report as the data changed in database, and how?

 

[CosmoKramer]

If you are indeed linked to this other database, then the data is refreshed each time you run the report. If the tables were imported, then you are working with a static copy and will have to re-import the tables each time you run the report.....

 

[kelvin24]

I imported the tables from the database. Is there anyway that i dont have to re-import tables manualy or create a marco to do this action?

 

[CosmoKramer]

You should link the tables instead. That way, you are viewing the database real-time.

From Access help (especially read the last paragraph):

Should I import or link a table?

Microsoft Access provides two choices for using data from an external source:

·	Import the data into a new Microsoft Access table in the current database.
·	Leave the data in its current location and use it in its current format without importing it - this is called linking.

Examples of external data sources include tables from other Microsoft Access databases located on a network, HTML and HTX tables and lists located on a local, intranet, or Internet server, and data from other programs such as Microsoft Excel, Microsoft Exchange, Microsoft FoxPro, Paradox, and Microsoft SQL Server.

If you know you will use your data only in Microsoft Access, you should import it. Microsoft Access generally works faster with its own tables, and if you need to, you can modify the imported table to meet your needs just like any other table created in Microsoft Access.

If the data you want to use is also being updated by a program other than Microsoft Access, you should link it. Using this approach, the current methods of updating, managing, and sharing the data can remain in place, and you can use Microsoft Access to work with the data as well. For example, you can create queries, forms, and reports that use the external data, combine external data with the data in Microsoft Access tables, and even view and edit the external data while others are using it in the original program.

 

[kelvin24]

appreciate your help cosmo. i didnt know that using linking table can connect to ODBC. It should be working now. thanks for the help.