Rename All Access Queries/Tables

Category:
Office/VBA
Type:
Snippets
Difficulty:
Intermediate
Author:
aaron

Version Compatibility: Visual Basic 6

More information:
This code will look in the current database and replace certain characters in the names of queries. This is for use withing Microsoft Access.

USAGE: Call RenameAllQueries("/", "")
USAGE: Call RenameAllTables("tbl", "")

If you need help, email Aaron_kempf@hotmail.com

PS - If you are an experienced _Access_Data_Project_ Developer_, email me and lets' chat about starting a consulting firm.

Instructions: Copy the declarations and code below and paste directly into your VB project.

Declarations:

Code: