Clone User

[jzjay]

Hi,
I am looking for more efficient way to clone users in my database and need some advise from you guys.

I have main user table and 6 related tables. In order to clone user, I initially create new user and insert the record into main user table.

and.. secondly,
I clone 6 related tables, basically by creating recordset and loop through the recordset and put the records into array, and put those arrays of the records back into table with the new User ID.

Would there be any better way than this ?

 

[dhookom]

Generally, running SQL statements would be more efficient.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]