is there an easy way to get rid of "AS Expr__" in queries?

[AAbrams]

Because of a migration, I had to rename some (a lot of) field names in a set
of tables. Of course, the queries which refer to these fields no are
confused and refer to expressions.

When I go in and and repoint the quey in the right direction, though, the
"Expr00" reference remains, which goofs up reporting based on the queries.

There are a LOT of query references involved - whoever designed this sucker
originally didn't do it right, and it is expressly NOT in my scope of work
to re-do the logic.

Is there any way to get the application to expunge the "Expr" references
without going in and manipulating each one by hand? The application is an
Access 97 database, running on an XP platform

Thanks in advance,

Alan

 

[John Nurick]

Hi Alan,

There's no built-in way. Many peope use tools such as Speed Ferret
http://www.moshannon.com/ and Find and Replace http://www.rickworld.com/
which can search and replace just about anywhere in Access. Or if you
enjoy text munging you could write VBA code that iterates through the
database's QueryDefs collection and adjusts each .SQL property as
necessary.