Is there a way to simulate the table documenter with VBA?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access database with one table consisting of 1,678 records that list Access databases. The fields in the table display server name, directory path, file name, date modified, and file size. For all 1,678 databases, I am looking for a way to create a report that would display all the information in the table plus corresponding database table names and for each table, corresponding field names, data types, and field lengths

If possible, I prefer not to open the databases because that changes the dates modifed. I can copy the databases to other directory paths to avoid changing dates modified. However, it does take time to set up so many new "duplicate" directory paths and copy the files

A few of the databases have passwords. Some of these passwords cannot be recovered with password recovery tools

I realize that the table names, field names, data types, and field sizes can be displayed by clicking on Analyze, Documenter from the Tools menu and then copying and pasting to a Word document. However, this manual process is very time consuming for so many databases. Is there a way to automate the process with code

I have coded VBA using ADO. I am not familiar with DAO

Thanks in advance
Anita
 
If possible, I prefer not to open the databases because that changes
the dates modifed. I can copy the databases to other directory paths
to avoid changing dates modified.
Click to expand...

You are certainly not going to be able to see inside a file without opening
it! I have not checked, but I would guess that if you open an mdb with the
Readonly parameter set True then it might not change the timestamp. There
are Touch tools that will set the date back again after, too.

If you were going to use the duplicate file approach, you could use a
constant TempFile name, which would provide another level of
simplification.

It would not be hard to write a short routine to iterate the Tabledefs
collection, and document the Fields collection for each of them: this would
be a lot more automatic than the built-in documenter.

Hope that helps


Tim F
 
Opening the files read only/exclusive does not change the
file time.


Chris Nebinger
 
Back
Top