AddRecord

Hi Group,

(Pardon my English, I'm from Holland)
I created a database in Access2000 and I want to link this to a application I am building using VB 6.0. Somehow VB 6.0 doesn't allow this.

I converted the database to Access97 and it worked fine!

How can I use the (original) database I created in Access 2000?

Thanks in advance!

Sander
jr-vb programmer

Check this article from Microsoft first. It should solve you problem.

http://support.microsoft.com/support...G=ENG&SA=ALLKB

Access 2000 Requires that you use the CDO 3.6 Library and not the 3.5/2.5 compatability library.

Change your reference to the 3.6 and you will be fine

Spyder

Thanks to both of you.

However, after reading the document one of you advised me to read and consulting a couple of collegues I still do not know how to change the library ref.

Could you please tell me how to do this.

Regards,

Sander

(Is this a really stupid question?)

Under VB6 , it is under

Project --> References

Just scroll down to the MS area and fine the refernece that you want.

-=D=-

By the way, It is the DAO that I am Refereing to, not the CDO. My appologies for getting the two backwards.

There is also a way to do this with ADO objects, but ALAS, I am just starting to experiment with it.

-=D=-