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.
 

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
Queries losing fieldnames when importing from external mdb 2
MS Word List Bug 0
Functions not working in Access 2007 Queries 9
query to show where no data in a stated column 0
multiple expression in Queries 4
Automatic Emails sent to my Contact Groups by Microsoft 1
Using "like" from an external link 1

Top