>>
>> Set oFox = Nothing
>>
>> Screen.MousePointer = vbDefault
>>End Sub
>>
>>Private Sub Form_Load()
>> Dim strOpen As String
>> Set oFox = CreateObject("weapondata.WeaponData")
>>End Sub
>>
>>
>>This needs to run unattended as the live data files will be large (about 400M) and the import process will require several hours.
>
>You stated you used the following syntax:
>
>sParams = "Do LoadData With " + sSourceFile + ", " + sDataPath + ", " + sTableName
>.DoCmd (sParams)
>
>I don't see how the above code ever worked since LoadData is a method. Try the following syntax from VB:
> oFox.LoadData(sSourceFile,sDataPath,sTableName)
>
>Murray

Didn't mean to indicate the code shown worked. I ported my development code ove to the runtime environment and it didn't work. I then proceeded to make what I thought were logical changes. They didn't work. Then tried the less logical ones. One of those is above.

Appreciate the note, will try it out and let you know how I finally get the thing running.

Again, thanks for the assistance.

Jim