Using MS Access/Queries

Advertisement


Question
I currently have a table in access and a bunch of queries connected with this table.  But now I had to add columns and change column titles to the table and none of the queries will update automatically with these kinds of changes.  Is there a way I can change all 90 of my queries without having to remake them all?

Answer
You must have an older version of Access because the newer versions will automatically update your forms, reports, and queries when you change the name of a field in a table (I know Access 2013 does this, at least, and I'm pretty sure 2010 and 2007 do as well).

An experienced Access programmer could write some VBA code to programmatically replace all of the text of one field name to another field name in the SQL statements behind your queries... but that's a pretty advanced move. Sorry.

What you COULD do is put the table names BACK the way they were, UPGRADE to Access 2013, and THEN make the changes. All your queries should update.

Be sure to visit my web site and watch my FREE 2-hour-long Microsoft Access Video Tutorial

Cordially,
Richard Rost
599CD Computer Training  

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Richard Rost

Expertise

I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site, and free Access 101 tutorial.

Experience

I am the president of AccessLearningZone.com and 599CD.com. I specialize in Microsoft Access Tutorials. I have been teaching Access in the classroom since 1994, and online since 2002.

Education/Credentials
I am a self-taught Access expert. I have been building databases for clients since the early 90s. You can see a sample of my Access Tutorials on my web site at 599CD.com

©2016 About.com. All rights reserved.