Copyobject and Array

[a]

I'm used copyobject to copy object to another data base

What I want:

I want Make array for every time I use copy object the name of the first
table change from Employee1 to employee2 and so on

DoCmd.CopyObject, "Employees1", acTable, "Employees"

 

[a]

Thank you very much for your help and answer

I’m sorry

I have 3 Question;

1- What the difference between Copyobject and TransferDatabase

I find Transfer Database is useful than copy object because not ask me about
name conflict like copy object

Copy object name conflict message:

The name you entered already exists for another object of the same type in
the data base

Do you want to replace the existing table?

Yes === No

2- (((Why))) the above message appear in copyobject and disappear in
transferdabase

3- can you write the array code for me to learn from you

Thank you for your time

 

[Jeanette Cunningham]

Unless you specifically want to get practice with coding arrays, it would be
easier to use TransferDatabase to do this.

Jeanette Cunningham