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