Re: strange corrpution has changed all the queries

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

--
Duane Hookom
MS Access MVP

"Nugimac" <nugiok@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ueXlTaeGHHA.1804@xxxxxxxxxxxxxxxxxxxxxxx
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" <DuaneAtNoSpanHookomDotNet> wrote in message
news:%23p8hgWbGHHA.1232@xxxxxxxxxxxxxxxxxxxxxxx
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.

--
Duane Hookom
MS Access MVP

"Nugimac" <nugiok@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:OgtfgUbGHHA.1248@xxxxxxxxxxxxxxxxxxxxxxx
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







.

Relevant Pages

  • Re: Beginner query help please
    ... MS Access MVP ... Duane Hookom wrote: ... I've noticed that if you select all the query output (in this ... Controls in most query solutions would not be ignored. ...
    (microsoft.public.access.queries)
  • Re: Beginner query help please
    ... MS Access MVP ... I've noticed that if you select all the query output (in this case ... Duane Hookom wrote: ... Controls in most query solutions would not be ignored. ...
    (microsoft.public.access.queries)
  • Re: Tricky query question
    ... Microsoft Access MVP ... "Duane Hookom" wrote: ... dynamic monthly crosstab report solution found at ... July data minus June data) in a crosstab query? ...
    (microsoft.public.access.queries)
  • Re: Formula will not work with mail merge
    ... There is code that does this in the Query By Form ... > How do I push the records to a separate Word Merge format file? ... >> Duane Hookom ... >> MS Access MVP ...
    (microsoft.public.access.queries)
  • Re: Crosstab Report
    ... MS Access MVP ... I try to write the report my headings/totals crash. ... "Duane Hookom" wrote: ... some of the information you posted to the query and found it very ...
    (microsoft.public.access.reports)