Copy/Paste does not copy a table from Access to SQL Server

[Guest]

I'm trying to make a copy of a table, in the same database, as a different
table name. I copy the table to the clipboard and then paste it. Access
prompts to enter the new table name, but then says it cannot find that name
(of course I'm just creating it) and won't do the copy.

Should this work?

 

[Roger Carlson]

It should work. Alternately, you could open your table in Design View and
then save it with Save As.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L