spattewar
asked on
Refresh Link Table automatically
I have created an Access Database which has link tables that point to a different database. Now using a report tool (Cognos) I want to query the Access Database and get the data into the report. BUT what I am worried of is whether the link tables will always provide latest data. Does the link tables get automatically refreshed when data is pulled from them.
Let me know if additional details are required.
Let me know if additional details are required.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Linked table are not 'refreshed' per se. They are direct pointers to the real tables.
mx
mx
ASKER
The Access database is used as a database by the report tool.
I will try it and will let you know. Thank you very much to All for responding immediately!!
I will try it and will let you know. Thank you very much to All for responding immediately!!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you all for your responses. I have split the points accordingly to the use of your response and the order of the response
ASKER