upsized from access to sql 2000

[tziviak]

I upsized my tables from access to sql 2000 -and the field name that had spaces in them -got an underscore in it's place.
since, I will still be running my queries from access , I changed the field names manually-back so they should have a space instead of an underscore (ex. [site id] instead of site_id)
but now, I can't enter/delete a record in sql and I'm getting a message: invalid name 'site_id'
so behind the scenes-the name wasn't really changed-so where do I change it? I changed the name of the fields by the table design
Thank you

 

[SQLSister]

Did you relink your tables after making the change?

 

[tziviak]

yes, of course

 

[MaffewW]

What method are you using to try and amend/delete the records?

 

[tziviak]

I actually tried 2 ways-using the query analyzer & by the enterprize manager->open table->query

thanks for trying to help me out