Copyobject and Array

  • Thread starter Thread starter a
  • Start date Start date
A

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"
 
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
 
Unless you specifically want to get practice with coding arrays, it would be
easier to use TransferDatabase to do this.

Jeanette Cunningham
 
Back
Top