>ok i decide to go with vb sp4 and mdac2.6 so i use the latest and i distribute the latest(dlls(sp4) and mdac(2.6)) so now again i'm stuck in same problem and along with exe, the project is also giving the same problem now.
>what changes shud i make in project .. in references i'm using microsoft activex data object 2.6 library and in components i'm using adodc 2.6.
>i've checked up my PC and mdac version on my PC is 2.6 RTM (2.60.6526.3) and no conflict at all.
>then why this probelm????
>plz help

Have you checked the MDAC_TYP.EXE version from your Redist folder ?