Retrieve MS Access DDB Property in Excel VBA

Hi
I need to be able to retrieve the DateModified property of an Access DB in
my excel worksheet. I already know how to make the connection, etc.....What
is the code to use to retrieve the last time the DB was saved?

Thank you

The MDB file 'Date Modified time stamp changes anytime the database is
opened regardless of any records being added or modified. So you may want to
query for the most recent record timestamp in some table within your DB

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"ibeetb" wrote:
| Hi
| I need to be able to retrieve the DateModified property of an Access DB in
| my excel worksheet. I already know how to make the connection,
etc.....What
| is the code to use to retrieve the last time the DB was saved?
|
| Thank you
|
|