Changing data structure in SQL with Access 2003 f/e

[Geoff Convery]

I've migrated an Access application to Access/SQL server using ODBC System DSNs and it's worked, however I now need to add a column to the main table.
I've added the column to the data definition in the test copy of the database using the Enterprise manager and, if I open the table using the Enterprise manager I can update the rows of the table but when I try to update the data using the front end I get a lock error message without the option of saving the record.
The lock error is only generated on the table I've changed and, if I link the front end to the live copy which still has its original structure it works perfectly.
As there's only me using the test copy and the same front end works with the unchanged data structute there has to be something wrong in the interface somewhere, but I can't sort out what.
Any ideas?

 

[Geoff Convery]

I think I've sorted this out (at least I've got a way that works). If I use the Query Analyser to make the changes with an Alter Table statement then it seems to be OK. Adding a dummy column in the designer and then deleting it with the Query Analyser also seems to work. Seems to be a complicated way round but if it works......