Is this a table?? How would I find where this info is coming from??

[KellyStee]

I have an Access database that someone else created and has been passed from person to person. It works fine.

I was curious how the guy actually got the data that generated the reports (and I need to use this data also), so I was looking through his queries, forms, etc. I can't figure out where he's getting the core data from. In the main query's FROM clause he has:
FROM [rep2:Order date and Quantity]

What is this?? I believe there are files stored on my hard drive that hold the information this query returns. Is this "rep" thing somehow looking at those files? How could I find out from about this table (or whatever it is)? There is only one table in the database (that I can see - can you hide tables?) and that holds lookup information for product codes/descriptions.

 

[CMooreJr]

you can hide tables. If you go into TOOLS/OPTIONS and click on the Tables/Queries tab, there is a check box for show table names. There should be a check in it.

This only applies to new tables, so any table that was created before the check mark was removed will show, any table that was made after the check mark was taken out will be autohidden....

hope this helps!

cmoorejr

 

[MichaelRed]

open any module and use search for the 'string' (rep:...) be sure to check the search settings are for 'current project'. You can do a similar search for any of the field names in the select clause, join clauses, or any field(s) named in the SQL statement. If any term is found within the code, you can find it this way.

Another approach is to open the system table(s) MSysQueries and MSysObjects and search for the same elements in the appropiate columns. While this is a bit more involved, it is well worth exploring these objects, particularly if you need to "ADOPT" an orphan or two.

For the latter, you can do an advanced search on either (both or parts) of the MSys like objects in these fora and find a plethora of 'interesting' uses and discussions.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[KellyStee]

I tried both of your suggestions. No luck. One thing. . .the database is an .mde file which, upon further investigation, seems to mean that all the coding is stripped out which makes it very hard to figure out where the table is coming from.

Thanks for the help, though!

Kelly

 

[MichaelRed]

I hven't actually tried this, but you should be able to access the MSys Tables from a different db using code. Then, the Sourcing info would be available to you.

On the other hand, if it id ".MDE" you can't make any changes (except to the actual field values, where some interface is procided) anyway, so the specifics of the derivation are not all THAT interesting or useful.



MichaelRed
m.red@att.net

Searching for employment in all the wrong places