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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Anita Mossey (almossey_nospam_at_yahoo.com)
Date: 04/21/04 

Date: Wed, 21 Apr 2004 16:46:06 -0700

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, and date modified. 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

Relevant Pages

  • Is there a way to simulate the table documenter with VBA?
    ... Some of these passwords cannot be recovered with password recovery tools. ... I have coded VBA using ADO. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Assign username/password to access file
    ... accessfile, how ... On Access 2002 with ADO, ... And unlike JRO's "CompactDatabase" this doesn't require the copy of a database. ... The square brackets round the [Passwords] are in case any of the passwords contain "strange" characters, such as embedded spaces, etc. ...
    (borland.public.delphi.database.ado)