documentor

[Guest]

I have an access db I'm creating for reports. I need to get the data from
another access db. I assume I can write a SQL query to this access db to get
the data since its on our network?

I don't understand this bigger db. It has 50+ tables. I tried to run the
documentor but I connect to it via terminal services. I unhide all the
tables on the relationship graph. I click the documentor but the terminal
server seems like it is going to take a long time. I would just like the
field definitions and relationships.

I have a question on naming conventions. If the table is named tblMyTable
then I know it is a table but if it is named dbo_tblMyTable what would that
be? If it is a database object does that mean it is a query not a table or
something else.

tia,

 

[Arvin Meyer [MVP]]

Use the sample code on my website to build your data dictionary. Just open
the database link the tables and run the form. It will do everything in less
than 5 minutes:

http://www.datastrat.com/Download/FieldDescription2K.zip

 

[George Hepworth]

I have an access db I'm creating for reports. I need to get the data from
another access db. I assume I can write a SQL query to this access db to
get
the data since its on our network?

I don't understand this bigger db. It has 50+ tables. I tried to run the
documentor but I connect to it via terminal services. I unhide all the
tables on the relationship graph. I click the documentor but the terminal
server seems like it is going to take a long time. I would just like the
field definitions and relationships.

I have a question on naming conventions. If the table is named tblMyTable
then I know it is a table but if it is named dbo_tblMyTable what would
that
be? If it is a database object does that mean it is a query not a table
or
something else.

tia,

 

[George Hepworth]

Typically, the dbo_ prefix indicates that this would be an ODBC-linked table
in a SQL Server database.

Are you sure these tables are in Access, not in SQL Server?

 

[Guest]

Not at all sure. I just looked at it and I've never looked at a terminal
server before.
Besides it is a really large db. I only need a few of the tables for my
report.

tia,

 

[Guest]

Maybe I should try using the documentor for only the tbl_mytable tables.
Maybe it is trying to document the SQL table and that is why it is taking the
terminal server forever.