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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append today's date to the name of the table 3
VBA - retrieve data on last create named range from previous inserted named range 0
Copying Linked Tables 1
CopyObject with Linked table 1
Copyobject and Array 2
Access macro 4
Don't show error message 1
Macro help 1

Back
Top