Copying one record with all children records takes about 10 seconds, which is more than enough coz we don't do more than one copying operation a week

Still, I want to...

I think that I provided all the required info

Can you give me any hint on implementing the same code using sets only?

After spending 8 hours, 1 hour planning and 7 hours doing the same routine task, I finished and tested the procedure using cursors

This is an excerpt of copying three tables...

Lowell (7/21/2009)

---

Scripting this out is not all that difficult; I slapped together the examples just from the top of my head...you just have to do it one piece at a...

Well, your answer made me look like a complete (grasshopper)!!

The code that he gave to me thankfully will not do the job

The following steps should take place, which I don't...

The database has many levels

I've attached a script for recreating the database

Did you check the last attachment?

Thank you for the reply

This solution will not work in my case since each child table has other children tables connected to it

So my database is arranged as a tree...

I found the problem!!

Both test machines were using the same public ip, that's why it didn't connect

I think that I can't connect the source ip to the same ip, right?

I think that it sounds really strange!!

I think that this is a very important feature, and there's no easy implementation for it?!!

Do you think that using replication will be easy...

thanks for your reply

but i can't even make an odbc connection, i wish that it was slow only!!!

can you please point me to any type of resources, even if it...

I'm using Access 2007 already

And...