How to Cycle Through Many TableDefs to Rename or Delete Many Tables in MS Access

In this episode, we'll relieve the pain for those of you who have hundreds of tables and linked tables in your database, as I'll show you how to make naming, deletion, and other changes to those tables en masse. This video will give you the ability to search by very specific criteria, then delete or make changes to linked tables or native access tables. We'll look at querying the system objects table, as well as cycling through the tables collection to make changes in your database. Pay attention to one big gotcha when deleting tabledefs on the way through!

Related Videos:
How to Cycle Through Many TableDefs to Rename or Delete Many Tables in MS Access
You are watching this video now!
How to Delete Duplicate Records in MS Access
   • How to Delete Duplicate Records in MS...  
How to Add an Index to Your MS Access Table
   • How to Add an Index to Your MS Access...  
How to Use Composite Keys in Microsoft Access
   • How to Use Composite Keys in Microsof...  
How RDBMS Relationships Work
   • How RDBMS Relationships Work  
How to use Transactions in MS Access - BeginTrans, Commit, Rollback
   • How to use Transactions in MS Access ...  
How to Manually Enter Values into an Autonumber Field in MS Access
   • How to Manually Enter Values into an ...  
Replication in Microsoft Access
   • Replication in Microsoft Access  

Interested in transforming your career or finding your next gig?
https://system.billzone.com/careers.html

Want my team to do a project for you? Let's get to it!
https://system.billzone.com/smdeproje...

Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :

  / mackenziedataengineering  

Demo of my BZ RDP Cloaker:
https://www.patreon.com/posts/how-to-...



Contact form you can find at http://www.mackenziemackenzie.com/

Follow me on social media:
  / mackenziedataanalytics  
  / seamacke  
  / seamacke  
  / seamacke  
  / psmackenzie  

Get Microsoft Office including Access:
https://click.linksynergy.com/fs-bin/...

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
https://www.tubebuddy.com/seanmackenz...


#msaccess #vba #dataengineering