tfifield (12/23/2010)

---

I think you'll find ADO much more flexible in VBA once you get used to it. You can even do some conditional tests in the statement like:

IF EXISTS...

The Dixie Flatline (12/21/2010)

---

tfifield (12/21/2010)

---

Much of what you want to do depends on the distribution of the data. If only a small percentage of the rows in the table...

tfifield (12/21/2010)

---

Much of what you want to do depends on the distribution of the data. If only a small percentage of the rows in the table have one or...

tfifield (12/22/2010)

---

Are you using ODBC Direct or ADO to execute the SQL statements?

I used to use ODBC Direct until Access 2007, which doesn't support it any more. I switched...

RBarryYoung (12/21/2010)

---

pdanes2 (12/21/2010)

---

RBarryYoung (12/20/2010)

---

I'd suggest that you Profile it and see what's really going on.

However, my suspicions would be that your Access engine is not executing all of your Statements...

Dave Ballantyne (12/21/2010)

---

pdanes2 (12/21/2010)

---

RBarryYoung (12/20/2010)

---

I'd suggest that you Profile it and see what's really going on.

However, my suspicions would be that your Access engine is not executing all of your...

RBarryYoung (12/20/2010)

---

I'd suggest that you Profile it and see what's really going on.

However, my suspicions would be that your Access engine is not executing all of your Statements / Batches...

tfifield (12/20/2010)

---

Rather than do all 3 tables in the same batch, try doing each table in a separate batch, which is to say a separate set of code in Access...

Access doesn't allow more than one SQL statement at a time. Each INSERT is a separate call. I have even...

Okay, ganging up up me... I'll try both methods and post the plans and results back here. It may be a couple days, though, I've got a monumental headache going...

No luck with anything, so I decided to go back to 2005. Did a fresh install of SSE 2005, re-attached the old database files and now I'm getting the same...

Hmm, yes, I should...

Dixie, Paul, thanks for the tips, at my current skill level with SQL Server, anything is welcome. It sounds as though an indexed view might be the best bet here....

WayneS (12/17/2010)

---

It sounds to me like the either the PK or a UNIQUE constraint is firing. The first runs fine because there are no duplicates; the second+ fails because of...

I had indexes on the auxilliary fields. Tried removing those, so that there is only the autonumber primary key, no luck. It's difficult to experiment, because everything I do to...