Connecting Tech Pros Worldwide Forums | Help | Site Map

Get Time Stamp when ODBC-linked table was updated

tod
Guest
 
Posts: n/a
#1: Nov 12 '05
My Access database has a link to a View in another database, using
ODBC. That view is updated by its database each day. I'd like to know
what time that happened. Is there a way I can find that?

tod
MGFoster
Guest
 
Posts: n/a
#2: Nov 12 '05

re: Get Time Stamp when ODBC-linked table was updated


tod wrote:
[color=blue]
> My Access database has a link to a View in another database, using
> ODBC. That view is updated by its database each day. I'd like to know
> what time that happened. Is there a way I can find that?
>
> tod[/color]

You'd have to have a column in the relevant table(s) that is a
dateUpdated column, then include that column in the View.

--
MGFoster:::mgf
Oakland, CA (USA)

Closed Thread