Queries changed from column names to AS Exprn !?!

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.
 
G

Golfinray

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.
 
Top