Renamed column - missing reference error

[facklis]

My Access (2000) Data Project connected to SQL Server
2000 is unhappy that I renamed a column in SQL Server.

The project consists of a form with a number of subforms.
When I open the form I get a series of four Access
message box errors: Invalid column name 'OldColumnName'.

However, when I open each subform individually, there are
no error messages.

The fields on the form and all subforms were created
using the form creation wizard. Each form/subform
corresponds to a different SQL Server table.

On the SQL Server side, when I renamed the column I made
sure that I changed every table in which it was
referenced, including all relationships, indexes, etc.

On the Access project side, I changed every field on
every form that referenced the old column name as a
Control Source. I also checked all form controls and code.

There are no references to the old column that I can
find, and I have exported the forms to a number of
different formats, including HTML and XML.

Any idea how I can find where the old column name is
being referenced and correct it?

Thanks in advance.

 

[Douglas J. Steele]

If the subforms open without error, the error is probably in either the Link
Child Fields or Link Master Fields of the main form.

 

[R.D]

Hi

I also had the same problem sometime back. I found this to be O/S, ACCESS
version problem.

Try using the same form on 2003 server, it is working again.

Try using repair tool , if still not working...

The best way to get rid of the problem is to reconstruct whole form . New
form will
definitely work.

R.D

 

[facklis]

Bingo.

Both the Link Child Fields and Link Master Fields
properties in all four subforms were referencing the old
column name.

For others: The Link Child Fields and Link Master Fields
properties are accessible in the subform properties only
when accessed through their open (parent) form.

Thanks very much!