Listing 'last used' date

[Mike MacKinnon]

Hi folks. We have literally hundreds of databases and my boss wants me to try
and produce a listing where we can idenatify the tables etc., and link a
'last used' date, in order to delete those that are no longer used.

Has anyone any ideas about how to go about this?

 

[Rick Brandt]

Hi folks. We have literally hundreds of databases and my boss wants
me to try and produce a listing where we can idenatify the tables
etc., and link a 'last used' date, in order to delete those that are
no longer used.

Has anyone any ideas about how to go about this?

I don't think there is such a property that coudl be used reliably for this. My
suggestion...

Rename any table that you suspect is no longer in use to ExisitingTableName_DROP
and wait a few weeks. If nobody reports errors then that raises the odds that
the table is in fact not being used. Import those tables into a separate file
and then delete them from your present file. If later on you discover that some
of the removed tables are actually needed you can re-import them from your
backup file.

 

[Tom van Stiphout]

On Tue, 18 Dec 2007 04:27:00 -0800, Mike MacKinnon

You can iterate over an entire drive (e.g. using Dir) and look for
MDBs. When found, record their DateCreated and DateUpdated properties
(I think you have to use the FileSystemObject for that).

-Tom.