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 (SELECT...

How large is the upload file? You may be better off loading the file into a staging table and then doing your inserts in small batches from a stored...

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 to...

All of the advice so far given is excellent. I would like to expand, however, on a point made earlier.

It is VERY shortsighted of your company to not give...

This type of totaling should really be done in the front end report engine. Access, Crystal, etc. all have this type of totaling available.

Todd Fifield

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 more...

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 each...

Brandie,

I'm coming into this rather late (traveling the last couple of days). You could try something like this with a CROSS APPLY:

SELECT

FCV.CoverageKey, FCV.SourceKey, FCV.EffectiveDt, FCV.CovRefundKey

, FCV.TypeKey, FCV.StatusKey

FROM...

Try to track down either a very large amount of data being inserted (you may have to ask around to see if anyone did this).

The culprit could also be a...

Chrissy,

I'm with Kevin on this one - get someone who knows to help you out and learn something from.

If you can't do that then here's some advice:

1. NEVER join...

Improving your skills as a DBA is only half of the equation. You should also look for a business or activity that you actually like or would like to...

Kevin,

I will stick by my statement simply because I can count on one hand the number of scalar UDFs I have seen at clients that are acceptable and cannot possibly...

Here's my 2 cents. I disagree with Kevin on this. Scalar functions can be very useful to encapsulate logic - especially for string handling and formatting like phone...

Actually, it's just plain easier to read and conceptualize the relationships between the tables as one is going along when it's done in the JOIN.

Todd Fifield

It would help if you would provide the table definitions and some sample data for each of the tables.

Todd Fifield