why does Access 'mess up' queries

[Ashank4vba]

Hello,

I have this access database with a couple of tables and queries.

For some reason, that I cant exactly pinpoint, sometimes the joins in the queries vanish and access adds 'Expr' aliases for some output fields in those queries.
I think I had 'Track Name AutoCorrect Info' unchecked at this time.
I delete and remake the tables used in these queries but I thought that having 'Track Name Autocorrect Info' option unchecked shouldn't mess the queries up due to change to the tables.

Please enlighten so that I can avoid this confusion in the future. Thanks.

-Regards
Arvind

 

[Zion7]

Queries Forum???

 

[easyit]

When you open a query and the tables/queries in it are checke for existice. If they are goen, well, then the links will be gone also.
This has nothing to do with autoname correcting.