Use Copy object and change name everytime

  • Thread starter Thread starter William via AccessMonster.com
  • Start date Start date
W

William via AccessMonster.com

I am trying to copy a table in access using a macro. I'm using CopyObject
I want to copy the table into the same database but with different names
every time.
 
William,

Yep, that should work ok. Are you having a problem with it?

Mind you, doing such a thing is very unusual, and almost certainly
indicates that your database design could be improved. If you would
like to explore this aspect further, please post back with an example of
the table you want to copy, and why you want multiple copies of the same
table, and someone will be able to advise.
 
Back
Top