<div>
That worked great! Thanks for that.<br />
<br />
I have another db that I need to do the same thing to, however I only want it to add the new field to table names containing the word &quot;details&quot;. Is there a way to modify that code to do that?<br />
<br />
For example, I have:<br />
Table1<br />
Table1_details<br />
Table2<br />
Table2_details
</div>


That worked great! Thanks for that.

I have another db that I need to do the same thing to, however I only want it to add the new field to table names containing the word "details". Is there a way to modify that code to do that?

For example, I have:
Table1
Table1_details
Table2
Table2_details

<div>
Awesome! Saved me a lot of time. Thanks!
</div>


<div>
<div class="content wysiwyg-content">
Hi guys, I have an Access 2010 database with about 90 identical tables and need to add a new field to all of them. Is there a way I can add the new field to all of them at once or do I have to manually go into each table one by one and add the new field?
</div>
</div>


Hi guys, I have an Access 2010 database with about 90 identical tables and need to add a new field to all of them. Is there a way I can add the new field to all of them at once or do I have to manually go into each table one by one and add the new field?

MS Access - Add new field to multiple tables

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.