Now I really broke things.
I had a table in sql server that needed changes that could not be made
So I made a new table and with all the correct attributes then renamed it the same as the old table.
then I tried to re-link the table in Access to the new table (with the same name as the old table)
and it tells me that it is not a valid name (also it is adding "PK_" to the front of the name)
I have done this before when creating a table in sql server and didnt have a problem what am i doing wrong