Archive one table and make a new one with the same name.

[Thales750]

Have had no joy fixing that busted table.
We downloaded it into an Access back end and made it work for the last two weeks. The clients needs it to be back in the SQL Server because they have a whole Chemical plant that uses that data and for their reporting software.

I imported a blank table a copy of the original that was migrated back to the Access Backend.
ran a query to add all the current records and now the new table works

The problem is now I need to archive the old table and create a new one with the same name even after I changed the named to an archived style name . From an Access point of view it doesn't mater, but apparently they have a rather complicated linking arrangement and they don't want to mess with it, so the onus is on me.

Does SQL Server hold these names forever?

Any ideas?

I think I'll make a copy of the data and try deleting the table and then renaming the new one.

 

[Isaac]

I'm confused on what your question is.

You want to rename a linked table in Access? Just right click and rename it.
You want to rename a table on SQL Server? I have used SSMS object designer to do that in the past, of course you could also select into ... then drop the original one.

Or is your question something else ??

 

[arnelgp]

instead of Re-creating same table, just Archive (copy) its record to a History table (in SQL server or access).
then delete the table's record.

 

[Thales750]

It seemed like there was a delay in the propagation of the original name change, in spite of refreshing the table twice.


Thanks y'all.