Use Copy object and change name everytime

[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.

 

[Steve Schapel]

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.