After alter table query on sql server no longer works

[tagteam]

I have an access database where most of the tables are in access but I have an archive table in sql server. Usually I am just appending data to that table but if a user makes a mistake I sometimes need to pull the data back to a working table and delete it from the archive table (the sql server table)

I used to have no problem with this but now my query says - could not delete from the specified table.

The only thing I have done to that table in a long time is I did do an Alter table to remove two columns. I used to not get these errors. If I log in to sql server and manually run a delete command it will properly delete but not if I try to do it from the access query.

Any ideas?

[CJ_London]

Perhaps the odbc driver is out of date. Perhaps you need to create a new link to your altered table.

[June7]

Instead of "moving" records, could just have one table and flag records as "inactive" with a yes/no field.

Not using an autonumber primary key? Or no related child tables?

[Gicu]

Refresh the link to the SQL table in your Access front-end and you should be OK. If not post back please.

Cheers,

[tagteam]

I tried refreshing the link in access and recreating the ODBC connection and in the end all I had to do was delete the table from access and re add it.
Thanks