Maybe mainmenu.VFP_DBC is invalid? What is actual value store in it during runtime? What is exact error mesage you get?
>
>I use your recomendation and work fine using VFP developer version, but when I create the executable give me the famous error Ole DB invalid path or file name. Do you know something about that. I try to check the connection but did not show any error. I am using the UNC name instead of the drive map. I switch to map drive and the error continue. Please let me know if I have to do something aditional. I can't catch the problem in the development.
>
>This is the code that I am using.
>
>oapp.ADODB.OPEN("Provider=vfpoledb;Data Source="+ALLTRIM(mainmenu.VFP_DBC))
>conrs =oapp.ADODB.Execute("OMSC_DELETED('OMSC_USER')")
>THISFORM.text9.VALUE= conrs.FIELDS(0).VALUE
>IF TYPE('conrs')= "O"
> conrs.CLOSE()
>ENDIF
>oapp.ADODB.CLOSE()
>
>I dont get any error in the development machine.
--sb--