Printable View
I have an environment where I cannot control the set-up:(
The DAO data control works fine. The ADO data control won't work at all.
I can't get either one to work in code...
What files do I need to set the environment up for ADO with Access 97. At home, I have just bunged on every file I can find and it works great...
Hopefully,
P.
not sure what you wanna do man
can ya elaborate"?
Well, how does the DAO DataControl connect? What DLLs does it use etc. Why can't I do it through code?
ADO is another matter, but I am not sure which files that needs to be supported.
General interest q really, not vital.
P.
hi,
I am not sure what you want. What i think is ADO and DAO are not installed properly. You can get the ADO from MDAC at the microsoft website's download section.
regards
That is what I think but I have no control over my environment:(:(:(
I need to know which DLLs are needed for ADO and which references do what so that I can argue it out with my IT department...
Cheers,
P.
I am having the same problems. I have developed an application on Windows 98 with Access 2000 and VB6 using ADO, but I have found that it will not install on systems running Windows NT, Access 97, and no VB. I have found out that, in order to use ADO, you must have MDAC installed on the client pcs. The Package and Deployment Wizard includes the MDAC install (MDAC_typ.exe). The problem is that installing MDAC can cause all kinds of problems (a.k.a. Dll Hell). I think I'm going to switch to DAO. I believe that DAO does NOT require MDAC, and you only need to include the DAO .dll (dao360.dll in my case) in the install to make it work. I am not positive this is true though. I'm looking for answers too.
Here are a couple of sites that may help:
http://www.able-consulting.com/ADO_Faq.htm#Q4
http://www.microsoft.com/data/MDAC21info/MDACinstQ.htm
http://msdn.microsoft.com/library/te..._redistmdac.ht
You can also go to this site to find out which dlls are installed with which packages:
http://support.microsoft.com/service...p?fr=0&sd=msdn
Good luck!
maybe the following demos will help
http://pages.about.com/vbmakai/dao.htm
http://pages.about.com/vbmakai/ado.htm