Effects of changing a table field name on queries/reports

[Atomsk]

I've ended up having to rename one of the fields in my table. Ideally I'd just work around it, but it ends up creating some big problems down the line. Is there any way to update all of my queries/reports for this field without having to manually edit all 900+ of them? It'll only take me a day or so, but it's still annoying. Thanks for any help.

 

[psemianonymous]

Boom!

http://www.rickworld.com/products.html

Download the trial version, make your change, and be done with it.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[Atomsk]

Thanks very much.