AddRecord

[visualsander]

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

[Dr_Evil]

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

http://support.microsoft.com/support/kb/articles/q238/4/01.asp?LNG=ENG&SA=ALLKB

[spyder]

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

[visualsander]

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?)

[spyder]

Under VB6 , it is under

Project --> References

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

-=D=-

[spyder]

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=-