Windows Forum

Ask something
Discussion Locked

Search & Document mdb files

0 helpful
3 replies

by sheryl v 2 views

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
We are about to do a major conversion to MS Access 2000. I can search our entire server from my NT PC or the server itself & see exactly what's out there, however I need to get the file names, paths. modified dates, etc. into Excel or a text file totrack down ownership & then relevance or obsoleteness etc. Any ideas?

3 replies

by d_v ant

Go to a command prompt and type "dir *.mdb /s /n > myfile.txt" sans quotes

This will search all subdirectories and give the date and times for the files and store the data in a txt file. Here is a sample of the output:

Directory of C:\Documents and Settings\XXXXXX\My Documents\Excel

02/14/2003 10:25a 147,456 Mockingbird.mdb
01/02/2002 03:17p 311,296 troubleshooter.mdb
2 File(s) 458,752 bytes

Open the file with Excel or Word. With Excel, you have toplay with the layout a bit.
It doesn't provide the owner information, but it shows you where to look.

Hope this helps

This discussion is closed to new replies.