VBA, JEt 4.0 with VB 6.0

Alexandre Magn
#1 / 5

JEt 4.0 with VB 6.0

Hello,

I want to use DbEngine v4.0 in Visual Basic 6.0 I'am sure that Jet 4.0 is
already installed in my computer. One of the reference I see in VB is
"Microsoft DAO 3.6 Object Library". Why I could not find "Microsoft DAO 4.0
Object Library" ? Where I can use this one ?

Alex

Wed, 20 Jul 2005 05:24:21 GMT

A. van Huize
#2 / 5

JEt 4.0 with VB 6.0

That's because DAO4.0 doesn't exist!!

DAO3.51 or less is part of JET3.5 and 3.6 comes with the JET4.0 SP.

DAO3.7 is 'part of ' XP.

Regards,

Arjan.

Quote:

> Hello,

> I want to use DbEngine v4.0 in visual basic 6.0 I'am sure that Jet 4.0
is
> already installed in my computer. One of the reference I see in VB is
> "Microsoft DAO 3.6 Object Library". Why I could not find "Microsoft DAO
4.0
> Object Library" ? Where I can use this one ?

> Alex

Wed, 20 Jul 2005 06:20:10 GMT

Alexandre Magn
#3 / 5

JEt 4.0 with VB 6.0

I just for forgot a litte thing.. Could you please reply to me and news
groups ?

Thank

Wed, 20 Jul 2005 06:23:24 GMT

Alexandre Magn
#4 / 5

JEt 4.0 with VB 6.0

Ok, I understand, but I still whit my problem. I have ask on newgroup how to
do a left join sql request with an union. Someone answer me and in the
answer the people say that I must use JET 4.0 to be able to run this
request.

My DbEngine.version is 3.6 and give me an error in the from clause in the
sql request when I'am trying to execute the request. Access 2002 give me the
same error. Here is the request :
SELECT card.*
FROM card LEFT JOIN (SELECT NomAbbr FROM zone UNION ALL SELECT NomAbbr FROM
group ). AS toto ON card.zone = toto.name
WHERE toto.name IS NULL;

Is there an error in this request ? Or I need to do something else for this
request to works ?

answer ?

Thanks

Alex

Quote:

> That's because DAO4.0 doesn't exist!!

> DAO3.51 or less is part of JET3.5 and 3.6 comes with the JET4.0 SP.

> DAO3.7 is 'part of ' XP.

> Regards,

> Arjan.

> > Hello,

> > I want to use DbEngine v4.0 in visual basic 6.0 I'am sure that Jet
4.0
> is
> > already installed in my computer. One of the reference I see in VB is
> > "Microsoft DAO 3.6 Object Library". Why I could not find "Microsoft DAO
> 4.0
> > Object Library" ? Where I can use this one ?

> > Alex

Wed, 20 Jul 2005 06:38:51 GMT

Marshall Barto
#5 / 5

JEt 4.0 with VB 6.0

Quote:

>Ok, I understand, but I still whit my problem. I have ask on newgroup how to
>do a left join sql request with an union. Someone answer me and in the
>answer the people say that I must use JET 4.0 to be able to run this
>request.

>My DbEngine.version is 3.6 and give me an error in the from clause in the
>sql request when I'am trying to execute the request. Access 2002 give me the
>same error. Here is the request :
>SELECT card.*
>FROM card LEFT JOIN (SELECT NomAbbr FROM zone UNION ALL SELECT NomAbbr FROM
>group ). AS toto ON card.zone = toto.name
>WHERE toto.name IS NULL;

>Is there an error in this request ? Or I need to do something else for this
>request to works ?

If that's an exact copy of the query you're trying to run,
then, yes, there are a couple of errors.

1) The . after the ) should be removed. Maybe this was
mistakenly left in from an A97 query where it was
needed?

2) The field in the ON expression is different from the
field selected in the union query.

I can't tell what you really want, but maybe this will be
close(?)

SELECT card.*
FROM card
LEFT JOIN
(SELECT NomAbbr
FROM zone
UNION ALL
SELECT NomAbbr
FROM group
) AS toto
ON card.zone = toto.NomAbbr
WHERE toto.NomAbbr IS NULL;

--
Marsh
MVP [MS Access]

Wed, 20 Jul 2005 12:22:50 GMT