Querying for last updated record

L

Lorra Rogers

I have a table that I am querying from that I need to be able to select the
record that was last updated. However, there is no 'last modified' field or
anything like that. Does Access keep this kind of information? Can it be
queried? I am using Microsoft Access 2000.

Thanks.

Lorra
 
M

[MVP] S.Clark

No and no.

Access does not track this information for you.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Top