documentor

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Janis - 30 Jul 2007 21:52 GMT

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,

Reply to this Message

Arvin Meyer [MVP] - 30 Jul 2007 21:58 GMT

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

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

>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
[quoted text clipped - 15 lines]
>
> tia,

Reply to this Message

George Hepworth - 30 Jul 2007 22:30 GMT

>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
[quoted text clipped - 15 lines]
>
> tia,

Reply to this Message

George Hepworth - 30 Jul 2007 22:32 GMT

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?

>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
[quoted text clipped - 15 lines]
>
> tia,

Reply to this Message

Janis - 30 Jul 2007 22:58 GMT

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,

> Typically, the dbo_ prefix indicates that this would be an ODBC-linked table
> in a SQL Server database.
[quoted text clipped - 20 lines]
> >
> > tia,

Reply to this Message

Janis - 30 Jul 2007 22:58 GMT

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.

> Typically, the dbo_ prefix indicates that this would be an ODBC-linked table
> in a SQL Server database.
[quoted text clipped - 20 lines]
> >
> > tia,

Reply to this Message