Find and replace table/field names in Access?
- by richardtallent
I've been handed a rather large, old, and crusty Access 2000/2003 database to clean up. I'll need to rename a number of tables and fields, but need to do so in a way that doesn't break existing queries. (Fortunately, there are no macros, forms, or reports to worry about.)
I've heard there are some commercial tools to make this job easier, but only found one (http://www.rickworld.com/products.html).
Can anyone recommend this software, or any alternatives?