Senin, 30 Oktober 2023

[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
_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116461) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Tidak ada komentar:

Posting Komentar