Queries changed from column names to AS Exprn !?!

  • Thread starter Thread starter mscertified
  • Start date Start date
M

mscertified

I had several queries that worked fine. Somehow all the queries got changed
by Access to have As Expr1... As Expr2 etc. for every column in every query.
This has caused a web page to fail that was relying on the column names.
Does anyone know what would cause this to happen?

Thanks.
 
If your query names go to expr you have lost your query or lost your tables
the query was based on. Check your tables first. Somtimes I will change a
table and forget to change my query and I get that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

strange corrpution has changed all the queries 4
query field names changing to expr#: 8
Functions not working in Access 2007 Queries 9
Decimal places and formatting within query! aargh! 1
Imported Queries & Field Names - Attn S.Clark MVP 3
add criteria to field that is based on named field 4
Queries losing fieldnames when importing from external mdb 2
Query from 3 other Queries 1

Back
Top