1. Change the table name back to its orginal name.
2. Download Rich Fisher's excellent Find and Replace add-in and change
everything to match the new table name. If you register it (one of the best
$37 I've ever spent), the cross-reference report can find what queries use
which reports and forms. It's a good way to find orphans.
http://www.rickworld.com/
3. Enable Name Autocorrect so that you won't have this problem in the
future. However Name Autocorrect is often a problem and I don't recommend
using it.
4. Remember that changing the name of a table, field in a table, query, and
possibly even forms and reports can cause this problem. It's better to get
the names right in the first place or don't mess with them.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"Aimee Proctor" wrote:
I changed the name of a table that relates to a lot of queries.....these now wont work....how do i resolve this....thanks for ANY news!
Submitted via EggHeadCafe - Software Developer Portal of Choice
ADO.NET Recursive Hierarchical DataSet Technique
http://www.eggheadcafe.com/tutorials...e-hierarc.aspx
.