Rather than a straight for loop like this I've seen

Do Until TestComplete()

   DoEvents

Loop

The TestComplete function returns a boolean, i.e. true if the task has completed.

Like I say, I've seen...

What is the error that is reported?

Have you checked that the macro security settings for access are the same on those machines?

Does the attempted connection show up in the profiler...

I'm making a few assumptions about the structure of your data here:

SELECT KitID FROM (

SELECT Count(1) as CountParts, KitID FROM (

SELECT * FROM Parts INNER JOIN KitParts ON PartID = PartID

WHERE...

To clarify what you need... Two tables Parts and Kits with a relation where each KitID has many Parts. Third table FindLists also related to Parts, where each FindListID has...

Here's a little function that will find the minimum...

Public Function Min(ParamArray Numbers())
Dim i As Integer
    i = LBound(Numbers)
    Min = Numbers(i)
    i = i + 1
    Do While i <=...

Oi, do you think you have exclusive rights to idoicy and stupidity? some of us are masters at it!

What was the...

What should the result be?

i.e is it access or sql that is wrong.

Try this code to call the sp...

Sub wibble()

on error goto error_handler

gSQLADOConnection.MergeDuplicatesDoMerge _

arrUserDet(0), arrUserDet(0)

exit_proc:

...

They look the same, but there might be an issue with type casting in there somewhere. And did you have to use an ampersand (&) in the table name as...

My first move would be to upgrade it to use an ADO connection and see what happens there. At least then you could look at the ado.errors collection and get...

I don't know about tsql but in the job you can have a cmdexec that has a call to xcopy which would do the job.

Just moving old data out to another filegroup won't give a performance boost. The performance comes from SQL server being able to overcome a disk I/O bottleneck by reading...

You have two levels in the hierarchy for each database, you can split a DB into filegroups and those filegroups into files. Normally a DB has one filegroup called PRIMARY...

I had to figure out how to do something like this in SQL2000, there may be a better way now so someone will be along RSN to point it out...

I...

Cool thanks for the feedback, looks like the upgrade should be fairly painless...

What is/where is the ready to launch utility?

"unbound, SP'd ADP/pure ADO" ahh such bliss! unfortunately this little beastie...