Sergey:
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.