In preparing to migrate to SQL Server, I need to write some code that would remove the spaces from table and field names. Here are the requirements:
From VBA in the front-end, go through each table in the back-end and substitute an underbar for a space
For example: BOM Parts becomes BOM_Parts
From VBA in the front-end, go through each table link (also in the front-end) and substitute an underbar for a space
For example: BOM Parts becomes BOM_Parts
For each table name, go through my code (recordset stuff) and rename all references
For example: [BOM Parts] becomes [BOM_Parts]
For each table name, go through my queries and rename all references
For example: [BOM Parts] becomes [BOM_Parts]
For each table name, go through my form and report properties and rename all references
For example: BOM Parts becomes BOM_Parts
Do the above for all fields with the addition of changing all # to num
For example: Component # becomes Component_Num
Does this sound doable?
Start Free Trial
