Sql server 2000 and MS Access Form issue

[yosharky]

Hi All,
We have a sql server 2000 with some databases. In one of the databases I have added a new column to the table that already has data in it. However the form that connects to the table now gives an error message window as follows:
------------------------
Write Conflict

This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made.

Copying the changes to the clipboard ytwill let you look at the values the other user entered, and then paste your changes back in if you decide to make the changes.
------------------------
The Save record is greyed out. Only options for Copy to clipboard and Drop changes are active

Thus it does not allow me to save any records now. But if I delete the new column from the SQL Table on the SQL server the same form allows to save and everything works fine.

Please advise.
Thanks.

 

[dhookom]

Did you re-link your table to Access after you added your field?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]