Renamed column - missing reference error

  • Thread starter Thread starter facklis
  • Start date Start date
F

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.
 
If the subforms open without error, the error is probably in either the Link
Child Fields or Link Master Fields of the main form.
 
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
 
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!
 
Back
Top