Re: [MSAccessProfessionals] Table Name Change

Hi Jim

 

I don't recommend renaming tables. Your applications could turn into Swiss cheese. There are third-party software that can help, but they all come with caveats.

 

Regards,

Bill Mosca

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Jim Wagner
Sent: Monday, October 30, 2023 12:31 PM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] Table Name Change

 

Hello friends,
Years ago in a very bad lapse of judgement and at the direction of my boss, we gave names to tables that reflected the system we were using. The system is long gone and we are moving away in 2025 to a new system. In the mean time, we are moving all tables to SQL as the back end. I would like to begin renaming the tables to a more clear and standard naming convention. Some of the newer tables we developed are standardized, so they are good now. The current naming convention is as such.
R&D-EMPLOYEEHISTORY
R&D-CURRENTEMPLOYEES
R&D-FMLAELIG1
R&D-LeaveFields2New

I would like to remove the R&D- and make them camel case with no spaces. I copied a database and tested it out with the auto-correct on. It worked like a charm, but all object dependencies are erased. Is there a way to not lose the dependencies or will they eventually be rebuilt after opening it a few times?

Thank You for your assistance

Jim Wagner