INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

I would like to be able to access t

I would like to be able to access t

(OP)
I would like to be able to access the "update date" of the various MS Access objects ... Forms, modules, tables, Reports Databases, ... et al as well as the sub entities. I can easily(?) get the various objects via the containers, but do not see any data properties associated with rather the containers or the objects "contained" therein?

MichaelRed


RE: I would like to be able to access t

I believe there is a Documents collection in the container, with a LastUpdated property. Something like tables.documents("sometable").Lastupdated

I may have the syntax wrong and I'm on an iPad at the moment so I can't test it.
Jim

RE: I would like to be able to access t

You just need to trawl the (hidden) MSysObjects table

RE: I would like to be able to access t

(OP)
Thanks to both. I was able to access both sources with only the confusion between seat & keyboard to delay obtaining the desired response. Delving through the container objects is somewhat more involved but yields a more compact set of information (suitable for the intent of this exercise). MSysObjects yields a much richer data set and is of course also more easily access - as long as operator is comfortable with SQL.

Then, MSysObjects also includes some data which is not readily understood (e.g. the LV* fields).

MichaelRed


RE: I would like to be able to access t

MichaelRed,
Glad you got this sorted but keep in mind the internals of MSysObjects etc are not documented by MS for our use so the results could be unreliable however they are the best alternative.

Also, your confusion is PEBKAC (Problem Exists Between Keyboard And Chair).

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

RE: I would like to be able to access t

> could be unreliable

Possibly - but the fields referencing the Created date and the Last Updated date in MSysObjects have not changed on at least 20 years, so I suspect we are safe enough...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close