See all Access files used in past month.

bfuchs
bfuchs used Ask the Experts™
on
Hi Experts,
I am looking for an Access file that was used about a month ago, however cant remember the name and since there were more recent files used, I cannot get to see them from under Access recent files list..
Is there any way I can get a list of all my Access files used in past month, along with date last opened?
Files can be either on the server or on local C drive.
Thanks in advance
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Owner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010
Commented:
you could open Windows Explorer, then search on ".accdb" or ".mdb", and then sort by date modified.
Scott CSenior Engineer

Commented:
Good thought....but what if the file wasn't modified?  But, you can add the column "Date Accessed".  Now either modified or accessed that should get you what you are looking for?
@Dale, I had run some queries (not sure if they were saved), tried the above, so far I could not find what I'm looking for, any alternatives?
@Scott,
but what if the file wasn't modified?  
This is the [dis]Advantage of Access, it will always change the date updated of the file, regardless if they were any changes done-:)

Thanks,
Ben
Thank you!
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Commented:
glad I could help, Ben.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial