By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,914 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,914 IT Pros & Developers. It's quick & easy.

Synchronising table field name change in back end database to front end client

P: 3
Hi,

I need to change a field name in a table stored on a backend database that is used by various queries, forms, etc on the front end client via a linked table.

I can't work out how to change the name in the b/e without having to change all the individual references to it in the f/e.

I haveauto name correct turned on in both f/e and b/e but I guess these are not related to each other.

Any suggestions please?

Rgds
Stuart
Mar 12 '08 #1
Share this Question
Share on Google+
1 Reply


Expert Mod 2.5K+
P: 2,545
Hi,

I need to change a field name in a table stored on a backend database that is used by various queries, forms, etc on the front end client via a linked table.

I can't work out how to change the name in the b/e without having to change all the individual references to it in the f/e.

I haveauto name correct turned on in both f/e and b/e but I guess these are not related to each other.

Any suggestions please?

Rgds
Stuart
Hi Stuart. You could use the Object Dependencies facilities to track down all objects which have a dependency on the linked table, then change all references to the old field name manually.

Since this is likely to be time-consuming and error-prone, do you really have to change the field name? You could always add a copy of the field to a query based on that linked table and alias that field in whatever way you want, then base whatever you need to feed with the new name on the aliased field. This would protect the integrity of all existing queries, forms etc in your current application.

If you really do want to change the field reference manually throughout right-click on the table and select Object Dependencies from the shortform menu. This will run for a short time and show you all queries, forms and reports that have a dependency on your linked table. You would then have to open these one by one, check their fields, and change the references yourself.

-Stewart
Mar 13 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.