I have approximately 50 queries that I refresh using VBA through a form I created. It works great. The problem is we recently got a new version of the application I link to through 0DBC. The fields in the tables used to have "Z" in front of them and now in the new database they have been taken off. I need to modify my queries to accommodate this but was wondering if there is an easy way to to this without having to create every query all over again. What a nightmare. Any help would be appreciated.