How to find out how an Access table was made?

[hank755_ca]

Hello,

Is it possible to find out how a table in Access was made? Especially
if it was made by a make-table query?

I have inherited a large database with close to a hundred queries and
tables. I am trying to make sense of it all

Thanks in advance.

[Rick Wannall]

Can't think of any audit trail that would reveal that, but I'll bite: How
would knowing how a table was created help you make sense of things?
Anything related to "these are permanent application tables, while these
other ones are recreated on the fly"?

[hank755_ca]

There are a couple tables that have strange data in them. I'm not sure
whether this data was taken from an already existing table (via a make
table query) or if it was manually created. It would save me lots of
time if I could find out.

Rick Wannall wrote:

Can't think of any audit trail that would reveal that, but I'll bite: How
would knowing how a table was created help you make sense of things?
Anything related to "these are permanent application tables, while these
other ones are recreated on the fly"?

[Rick Wannall]

Two things come to mind:

Search through modules using CTRL-F to find either table name.

Or use

SELECT o.Name, q.Expression, q.Name1, q.Name2
FROM msysobjects AS o INNER JOIN msysqueries AS q ON o.Id = q.ObjectId
WHERE (((o.Name) Not Like "~*") AND ((q.Expression) Like "*mytablename*"))
OR (((o.Name) Not Like "~*") AND ((q.Name1) Like "*mytablename*")) OR
(((o.Name) Not Like "~*") AND ((q.Name2) Like "*mytablename*"));

IF the table name pops up in any of the query text you could examine that
query to see what it's doing.

[hank755_ca]

Brilliant! The SQL gave me some valuable clues. Thanks so much!
Rick Wannall wrote:

Two things come to mind:

Search through modules using CTRL-F to find either table name.

Or use

SELECT o.Name, q.Expression, q.Name1, q.Name2
FROM msysobjects AS o INNER JOIN msysqueries AS q ON o.Id = q.ObjectId
WHERE (((o.Name) Not Like "~*") AND ((q.Expression) Like "*mytablename*"))
OR (((o.Name) Not Like "~*") AND ((q.Name1) Like "*mytablename*")) OR
(((o.Name) Not Like "~*") AND ((q.Name2) Like "*mytablename*"));

IF the table name pops up in any of the query text you could examine that
query to see what it's doing.