strange corrpution has changed all the queries

[Nugimac]

2003, XP, all service packs. All the queries have changed their field name.
here is an example.
tlkpWorkDesc.WDesc has changed to Expr1: tlkpWorkDesc.WDesc
tlkpWorkDesc.Item has change to Expr2: tlkpWorkDesc.Item

Every field in the query has the field name preceded by Expr and a number
the first field has Expr1, the second field has Expr2, the next has Expr3
and so on.
This has happened to every query.

I wish I knew what I have done that has caused this to happen.
If anyone can tell me, I will be careful not to do it in future.

Nugi

 

[Duane Hookom]

I would expect to see this if the table names had been changes or were not
in the "FROM " clause of the query.

You haven't provided the complete SQL view or told us if your MDB contains
the table tlkpWorkDesc.

 

[Nugimac]

Hi Duane, yes the table tlkpWorkDesc is in the db. There are 20 tables in
the db, some are linked from the backend, some are lookup tables in the
front end.
I should mention that these are saved queries, not ones written in VBA code.
Every single query in the db, approx 100 is affected in the same way.
Even a simple that just has the autonumber ID and another field.
All the queries are affected, no matter how simple or complex.

I would love to know what I did that caused this to happen.

Nugi

 

[Duane Hookom]

I already suggested the only cause that I am aware of.

 

[Gina Whipp]

The only time I've seen that is if the backend somehow got disconnected from
the front end (and you had no warning). As far as the frontend is concerned
you have no tables. The only 'cure' I know is to write a RelinkTables() mod
so the database checks each time it's opened to confirm the backend is there
and if it's not will prompt the user to relocate the back end.