VB 6.0 cannot access upgraded Access 2000

[CrazyHorse]

Hi, I upgraded from Access 97 to Access 2000 recently. Whenever i try to access Access 2000, it give me a "unrecognized database format" error. I did some research and found out thats it because of outdated DAO and ADO (whatever that means!)

The "remedy" at the microsoft site does not help. I access the database using the Databound control and setting its properties on the right. Whenever I click on the data source property it says "it doesnt recognize the database format". Interstingly the databases which are originally 97 are accessed without problem. Now my questions are:

1. What do i need to upgrade/download
2. Where can i get these downloads for free
3. Do i have to upgrade both Access 2000 (the database components)
4. Do I have to upgrade just the VB6.0 (service packs?)
5. Will I get this same error if i try to access it via script instead of setting properties? (I havent learnt it yet)

It would be great if you can provide me with the links also. thank you in advance. i'm a novice at programming.. so a little descriptive detail would be great and this is my first post here in any of the forums on this site.

thank you
CrazyHorse!!! [sig][/sig]

 

[Ruairi]

To upgrade your data access components (ADO and DAO, among other things) you need to install the newest version of mdac. This is available at microsofts website (the filename should be mdac_typ.exe). I dont know if this will update your data controls also, i never use them. [sig]<p>Ruairi<br><a href=mailto:ruairi@logsoftware.com>ruairi@logsoftware.com</a><br>Experienced with: <br>
VB6, SQL Server, QBASIC, C(unix), MS Office VBA solutions<br>
ALSO: Machine Control/Automation using GE and Omron PLC's and HMI(human machine interface) for industrial applications[/sig]

 

[CrazyHorse]

Thank you Ruairi

I will check on that and update you

-CH [sig][/sig]