Jet 3.5 vs jet 4.0

[ycim]

I have just moved from VBA to creating VB6 programs. I am using Access 2000 for a backend database, which is jet 4.0. My copy of VB6 does not see it as a valid database.

I can connect using ADO, but I have had some "learning challenges" trying to use ADO. So, I have jumped back to using DAO until I am more comfortable with VB6.

Is there anyway, without using ADO, to connect to a jet 4.0 database?

Thanks for your help.

 

[johnwm]

You need to apply SP6 to your VB6. Free download from:

http://www.microsoft.com/downloads/...db-2e89-4676-a16a-5c5477cb9713&DisplayLang=en

It will then see Jet 4.0 as a valid DB. Check out your MDAC version as well. If you must use DAO then use MDAC 2.5. Otherwise update to current version (I believe 2.8). You consider learning ADO so that you can migrate to MSDE and SQL (if required). You will also have a straightforward migration path to many other DBs.

There are many tutorials on ADO, including:

http://www.ipdg3.com/tutorialresults.php?option=tutorial&id=000026

http://www.w3schools.com/ado/default.asp

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Essex Steam UK for steam enthusiasts

 

[ycim]

Excellent! Thank you. I know that I need to make the stretch to ADO, as I plan on working wiht SQL in the future. I find that coding with ADO ie..setting connection string, making recordsets, etc is not that difficult. I am, however, challenged (of all things) with the ADODC object. Little things, such as FIND, no longer work the same, and make life very frustrating.

I downloaded the sp6! Works great!

Thanks for the tutorial link. That was an awesome touch!

 

[ycim]

Let's backtrack a minute. I installed it (that was great), but I still can't get it to recognize my Access 2000 database. Still gives me a "Unrecognized format" error.

What am I missing?

 

[fredericofonseca]

can you show us your code, specialy your connection string.


And if you haven't done it already download and install MDAC 2.8



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[ycim]

If I code a connection string through ADO, then it connects ok.

The problem I am having it connecting the DAO data control to the Jet 4.0 version of the database. I have installed SP6.

I downloaded MDAC 2.8, but received this message:

MDAC 2.8 RTM is incompatible with this version of Windows. All of its features are currently part of Windows.

The DAO datacontrol is connecting through the DATABASENAME property. Connecting to the jet 3.5 is easy, but if I try to connect to the 2000 version, I get "unrecognized format'.

Am I missing the boat here? Or I am I just going to bite the bullet, and start using the ADODC control?

 

[fredericofonseca]

That error is a bug.

http://support.microsoft.com/default.aspx?scid=kb;en-us;318251

Reinstall MDAC according to the above link, and then install MDAC 2.8 SP1 from

http://msdn.microsoft.com/data/mdac/downloads/default.aspx

Regarding the "unrecognized format" see

http://msdn.microsoft.com/library/d...98/html/vbconintrnscdatactrlandaccess2000.asp

I would still change your programs not to use data bound controls if possible. If you don't wish to do that then at least move the controls to ADODC.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[ycim]

Thanks...I will try this. You are the second person, however, to tell me to stay away from databound controls. Why is that? Coming from an Access VBA background, databound controls are the primary way to code. What makes it different in VB?

 

[fredericofonseca]

search

http://www.deja.com

for "bound controls versus unbound".

You will find plenty of threads explaning the reasons why.

but mainly with Data bound controls you don't have much control over it.
With code you have full control over when and how you data gets from/to the database.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[ycim]

I "fixed" the bug, and that worked, but when I went to reinstall MDAC 2.8 sp1, i received the following message on install

This setup does not support installing on this operating system.

I am running XP Home SP2, which came with the computer. Would this have anything to do with this error message?

 

[fredericofonseca]

did you do what is mentioned on

http://support.microsoft.com/default.aspx?scid=kb;en-us;318251

??

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[ycim]

yes...followed it through. seemed to be ok...didn't have any errors.

 

[fredericofonseca]

also have a look at

http://support.microsoft.com/default.aspx?scid=kb;

[LN];307255


Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[ycim]

ok....mdac 2.8 sp1 installed! Thank you! I am still working through the "unrecognized format" for the database.

 

[ycim]

Whoohoo! it works!
Thanks, everyone, for all advice, help, and getting my machine updated!