Record Layout

  • Thread starter Thread starter Steve S
  • Start date Start date
S

Steve S

Access 97 has a Documenter under the Analyze box that allows you to view or
print the layout of a table. How is this done in Access 2002 or 2003?
 
The Database Analyzer dosn't seem to be an option when working with an ADP
file. Am I correct? If so, is there another option to print a record
layout?
Thanks
 
The Database Analyzer dosn't seem to be an option when working with an
ADP file. Am I correct? If so, is there another option to print a
record layout?

You can "roll your own" using the SQLDMO object, which gives you
programming access to the database objects similar to DAO and Jet.

Or you can look for a third party database tool -- there are lots on the
market (e.g. embarcadero, etc) but they do have prices.

If you are using proper SQL Server, then the Enterprise Manager (?) comes
free with it and gives you a GUI management tool, presumably with ways to
print out. On the other hand, if you are poor like me and relying on MSDE,
then it's a bit harder. I heard that you can download the trial version of
SQL Server, ditch the actual db engine but still keep the management tools;
but I can't guarantee (a) that it works or (b) that it's legal.

Apart from that, you are back to relying on your original design
documentation.

Hope that helps


Tim F
 
Back
Top