Cannot locate source of table references

[moishier]

I have a database I took over, that generally uses linked tables to a MYSQL servers on another machine. The Access database uses a machine DSN to connect.

There are many queries that contain references to linked tables using another name. For example, the table is "service unit" but the queries are using "SU" as a reference. I cannot find any database object with that name SU. There are many such tables referenced like this - all uppercase letters, which is a common thing they all share.

Now, the server had a file integrity issue, and now the queries that contained the SU references will not work anymore. I created a linked table and called it SU and but the queries still won't work until I edit the queries, remove the old SU table, and add the new one in.

So,

1. Any idea where those table references could have come from, if it's not a linked table? Is there a hidden location on the server, or in the access database that stores another connection method?

2. Why won't simply adding a similarly named database object work the same way? Why must I re-edit all the queries?

All help would be much appreciated!

 

[pbaldy]

It sounds like an alias. Look at the FROM clause of one of the queries in SQL view. I suspect you'll see:

FROM ServiceUnit SU

or

FROM ServiceUnit As SU

if so, it's just an alias so you can use the shorter SU elsewhere in the query.