I have a VB6 program that uses Access 2000 with a DAO control that's DAO 3.6. In the connect pull down in the DAO control I find both Access and Access 2000 listed. No problem.

I setup a second computer installed VB6 and copied my programs. The intention is to use the new computer to continue developing.  Bad news, the pull down in DAO control on this machine does not show Access 2000 as an option.

The machine that works has XP home version, Office 2000, and VB6 pro. The new machine has XP pro and VB6 pro. I have loaded all of the service packs. They are both reference DAO 3.6.

I thoulght that I fixed this in the old system by installing the service packs. Looks like I forgot what it was I did.

I searched and found discussions that did not shed any loght on this except on person seems to think what I'm doing is not posible. What did i miss??

Huh.... I was thinking there would've been something else to install... A Jet update or something.  But considering everything that was installed - I thought maybe it would've already of been done.

Maybe look to see if there's any "Microsoft JET" update things.

____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)

Hi
Sounds like you need to install MDAC
I'd suggest:
MDAC 2.6 (for the odbc drivers)
then MDAC 2.7 or higher

Regards
Kieron


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)

MDAC comes with XP its part of the operating system. I tried installing it anyway as it was mentioned in an older discussion. Also Jet 4.0 is installed. Any other ideas?

Can you use ADO instead?  It probably does support it.

____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)

DOA supports it. I see no reason to rewrite all that code when it works now on the other computer. Something is missing on the new computer. That is on the old computer.
The working machine has XP home version. The unworking one has XP PRO. Both have Office 2000 installed. I'm sure I got the service packs. If no one has any ideas I will try uninstalling VB and then reinstalling it.  Thanks for your efforts I will let you know what the fix turns out to be.

HI
Swapping out the DAO control for the ADO one isn't much work.
But.. I did notice MS article on issues with Access and the DAO control. http://support.microsoft.com/kb/238401

Theres an article on MDAC compat issues too http://support.microsoft.com/kb/237994/en-us

.. and ODBC Jet stopped being shipped post mdac 2.6 http://support.microsoft.com/kb/219293/en-us

so depedns on how you're connecting



Let us know how you got on
Regards
Kieron


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)

I think you help there. What's happening is the Service Packs are not installing.  I checked the working machine and the about box shows SP6, while the non working version does not show any SP number.

When i run the installs it appears to be installing the service packs but appearently its not.  I'll see if I can what I can find out about why the service packs are not installing.  

The fix was to get Service pack 3 to install. I was unablel to find SP3 on the net but got in installed from a Visual studio disk. Installing service pack 3  allowed me to install service pack 5 and service pack 5 updates the DAO to include an Access 2000 option.

Thanks for all your help.  Your suggestions got me pointed in the right direction.