Which query created the table?

[muster]

Is there an easy way to find it out what query created a specific
table, by builtin functions, tables or code?

Thanks!

 

[Pat Hartman \(MVP\)]

Right click on the table name and choose Object Dependencies. You will have
to turn name autocorrect on for this feature to work. It will prompt you if
necessary.

 

[Jeff Boyce]

I'm not aware of such a 'back-trail', but then there's lots about Access I
haven't learned yet!

I'm curious though ... I assume you are talking about a Make Table query,
since none of the other query types actually create a table?

And I'm curious further ... why do you care? What will knowing which query
created the table let you do?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[muster]

First, I'm not sure Obj Dependecies work for that purpose. But I'm
sure it screwed my queries. So I'm looking for another way.

Second, say, when a table is missing a record and I'm looking for the
source, then I want to know what query created that table so I can
look in the query. Is there another way to do this kind of thing?
Please let me know.

One stupid solution is to look in all make table queries and find
which one did that (either by hand/eye cooperation or by code), but
isn't there a better way?

Thanks you all,
Muster

 

[John W. Vinson]

Is there an easy way to find it out what query created a specific
table, by builtin functions, tables or code?

Thanks!

No. Access doesn't care and doesn't record that information.

John W. Vinson [MVP]

 

[John W. Vinson]

One stupid solution is to look in all make table queries and find
which one did that (either by hand/eye cooperation or by code), but
isn't there a better way?

Well... I almost NEVER use MakeTable queries in the first place.

If you're routinely using MakeTable queries to create tables, you should
consider whether there is any need to do so. You can base a Report, or an
Export, or a Form on a Select query; if you're assuming that you must copy
data into a Table in order to report it... you don't!

John W. Vinson [MVP]

 

[dbahooker]

looking through all queries and see which one made it?

that's like.. what 3 short lines of code?

ROFL

 

[muster]

I agree. But hey, it's not me who want to make tables or want to use
Access in the first place.

I only want to make my own life easier. Anyway I think I can look in
AllQueries or some to get that or just use my big eyes!

Thank you.

 

[dbahooker]

I _STRONGLY_ disagree

using temp tables in the SQL Server world? it is fun for the whole
family


yeah; they're a little bit cumbersome; they're not the best for
_EVERYTHING_ but life wouldn't be possible without temp tables





the punchline of course.. is that makeTable (insert into) are non-
logged.. or minimally logged statements.. depending on the type of the
database

it's basically 'faster to write to a temp table than any other table--
because there isn't logging)

I just think that MS should throw away MDB and focus on ADP.

MDB IS MOTHER ****ING CRAP

 

[dbahooker]

Muster

you _SHOULD_ be using access.

But using MDB is just god damn ridiculous.

Access Data Projects are the bee's knees


-Aaron
ADP Nationalist