Can't change field name

[RichO]

I am working with an Access DB with a SQL server back end. This was developed by a former employee and my knowledge of SQL server is limited to creating, editing and linking tables.

In one existing table I changed a number of the field names but there is one field name that appears to be linked somewhere within the DB because when I go back to Access, refresh the link and then attempt to open the table in datasheet view, I am being asked to "Enter Parameter Value" for the old field name, followed by an ODBC failed error. I have looked through SQL Server and the DB looking for some kind of established relationship to this field name and can't find one anywhere.

Any help would be appreciated.

Thanks much.

 

[SQL_Hell]

Hi

Have you tried changing the filed name in SQL server enterprise manager?

 

[RichO]

That's where I'm changing it.

 

[SQL_Hell]

Hi

You could try removing the linked tables completely and re-linking, maybe even create a new database and link the tables there and see if you get the same problem.

Alos check that there is no constraint on the problem field in enterprise manager

 

[RichO]

I deleted the link and re-linked the table and that cleared up the problem!

Thanks for the suggestion!