SP4, install it, or will it mess up my DAO with Access97?

[bigfoot]

I received SP4 for VB. The documentation is kinda bad. What's it going to do to my existing code?
Has anyone used it?
What about DAO and Access 97 support?

I am moving to ADO and Access2000, but it will take a few months.

Thanks

-Gary They never have to knock if your door is always open.

 

[edderic]

if you install Access 2000 then you have the DAO 3.6 dll as DAO referense ,DAO 3.6 can read Access 97 and Access 2000 but you most som thing change in code :

Dao 3.6 can not read a Table declaration (Dim As Table) its RecordSet etc..

ADO 2.5 have another problems (you can not .Edit a recordset with codes as in DAO .edit) ,its declaration is not Dim As RecordSet but Dim test As New ADODB.Recordset.

etc...

>but it will take a few months.

Thats the world of a programmer ;-)

Eric De Decker
vbg.be@vbgroup.nl

Licence And Copy Protection AxtiveX.

Download Demo version on my Site:
Promotions before 02/28/2001 (free source codebook),visite my site

http://www.createsoftware2000.com

 

[bigfoot]

So will I have to change my curent code?

I have Access 97 and 2000 loaded on my workstation (W98)

I found an article on how to load'em both.

-Gary They never have to knock if your door is always open.

 

[edderic]

Nice you can do it (its not a wonder of the world)

Whe are talking in Visual Basic (yes or no ?),the next vijf days if you updated VB source code from Access 97 To Access 2000 i find here +/- 10 threads of Bigfoot with problems.

Succes

Eric De Decker
vbg.be@vbgroup.nl

Licence And Copy Protection AxtiveX.

Download Demo version on my Site:
Promotions before 02/28/2001 (free source codebook),visite my site

http://www.createsoftware2000.com

 

[bigfoot]

Yes, we were talking.
Thanks, on the Object thing. It's hard when you can't re-create a problem your users are having in the field. This forum is very nice in that I am the only developer currently at my company. This forum is like working with you all at arms reach.
I also answer questions from time to time.

I only wish Microsoft had a forum that was monitored.
-G They never have to knock if your door is always open.

 

[edderic]

<This forum is very nice in that I am the only developer <currently at my company.

RE :Tek Tips Forums Visual Basic is very nice and I love it but for me is it a kick to answer VB questions.

and for me is not Tek Tips the only on the World (it's One)

if you the only developer there are 1.000 Site's of Visual Basic on the internet... with answers.

Eric
Eric De Decker
vbg.be@vbgroup.nl

Licence And Copy Protection AxtiveX.

Download Demo version on my Site:
Promotions before 02/28/2001 (free source codebook),visite my site

http://www.createsoftware2000.com

 

[bigfoot]

Do you have any more of your favorite sites that you'd like to share?
I'm always looking to help others, and answers to advanced topics. Now I'm teaching myseld COM. I think it's like an ActiveX tool, but without an interface.
I'm also looking for documentation on VB's ActiveX Document.

Thanks ahead of time

-Gary They never have to knock if your door is always open.

 

[edderic]

ActiveX documents look at :

http://www.aivosto.com/visdev/vdmbvis58.html

A good VB site =

http://cuinl.tripod.com/

For Connections :

http://www.able-consulting.com/ADO_Conn.htm

another good VB site :

http://www.vb2themax.com/ItemBank.asp?PageID=TipBank&Cat=130#CAT

Or another :

http://www.vbweb.co.uk/dir/?id=10

Eric De Decker
vbg.be@vbgroup.nl

Licence And Copy Protection AxtiveX.

Download Demo version on my Site:
Promotions before 02/28/2001 (free source codebook),visite my site

http://www.createsoftware2000.com

 

[bigfoot]

Thak you

-Gary They never have to knock if your door is always open.