Data Control Error - "Unrecognized database format" 2

[SSJpn]

I put a data control on my form and set the DataBaseName property to point at my MS Access database. Then when i go to change the RecordSource property I get a message box with the error "Unrecognized database format 'C:XXXX\XXXX\XXXX' where XXXX\XXXX\XXXX is the location of my database. What is the problem?

Thanks,

Kevin.

 

[CmPaiva]

Sorry my intrusion, but its only to alert that you MUST change in REFERENCES, from DAO 3.51 to DAO 3.6
in order to have Access 2000 in the dropdown of connect property.

I hope this helps,
Carlos Paiva

 

[CCLINT]

Ummm, no you don't.

The DAO DC doesn't need any explicit references to DAO in the VB project, and is self contained.

[/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}

 

[CmPaiva]

No,
both systems coexist in system.
I have applications running both references in same system.
DC contents change acordingly with DAO reference.

Carlos Paiva

 

[CmPaiva]

A correction is due:

This only happens for already existing forms with dc on it. If you remove it from form and reload it, it will reference the new one.

Carlos Paiva

 

[CCLINT]

>both systems coexist in system.

That's not what I'm saying.

Of course you can have 3.51 and 3.6 on the same sytem.
(though only one of them referenced in a VBP at a time)

The DC does the references itself to the DAO 3.6 libraries which it needs and has nothing to do directly with the references in your project.

You only need the correct DC (Updated from SP4+) and the correct DAO dlls on your system (also added with SP4+) and the new DC in your project.
[/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}

 

[CCLINT]

You can remove the reference to DAO 3.6 in your project completely.
Still works.

You can change the reference from 3.6 to 3.51 in your project.

The new DC always uses DAO 3.6.

The only thing is that DAO 3.6 still needs to be on the system and your project needs to be using the new DC.

So, you could, for example, reference DAO 3.51 in your project, use a database object with that to connect to a '97 MDB, and also use the newer Data control to connect to a 2000 MDB or a '97 MDB.

If you do not reference the DAO 3.6 library in your project, you will need to add it to your set-up configuration when deploying your project.
This can be done with the Jet 4.0 Service pack.

So, again, it has to do with the DC being the wrong version.

Another way, for VB5 users when using the older control, is to set a reference to DAO 3.6 in your project and use recordset objects created with it, and the set the 3.51 data control's recordset object to your recordset objects created with DAO 3.6:

Set DataControl351.Recordset = rs36



>If you remove it from form and reload it, it will reference the new one

SSJpn:
I guess I assumed this, as it is a new control (VB5 vs. VB6).
CmPaiva's corrected statement in saying you need to remove it and add the new one manually, is right.

Or start a new project.

Or use the upgrade utility under:

\Programs\Microsoft Visual Studio\Common\Tools\ProjUpgd\PrjUpgd.exe.

I think this will do it also - it has been a while since I used it). [/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}

 

[CmPaiva]

CCLINT

All you said is right!
What i said, is only for reverting old programs to new 3.6,which it seems to me to be the problem.
Anyway, if he gonna work with DAO, apart form DC, it maus reference anyway 3.6 to access Acess2000 database.

By the way, a star on your explicit and exact explanation of the problem.

Regards
Carlos Paiva

 

[CCLINT]

Well, thanks for reminding me (the change out needed). I will try not to forget that and assume the next time.
[/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}

 

[SSJpn]

SSJpn

Whoa~ now I'm getting a little confused.

CCLINT - this is the name of the file I used 'vs6sp5vb.exe' and I got it from

http://msdn.microsoft.com/vstudio/downloads/updates/sp/vs6/sp5/dnldoverview.asp.

There were 3 downloads available: -Full, -Visual Basic, -Visual Fox Pro etc. I downloaded the Visual Basic one.

I wouldn't really say that i 'installed it', but rather it seemed like all it did was exact some files to a folder of my choice. Does that seem right to you?

To everyone:

Im just starting the program so I don't have to update anything. Right now I have a basically empty form with one control, my data control, which im trying to connect to my MS Access 2k database. I guess I've just been getting the wrong downloads because I still dont see the 'Access 2000' option in the dropdown menu of the 'Connect' property.

Do I really need to do all this 'referecening' stuff?

I don't need to do anything fancy, all I want is to be able to link to my database via the data control of my form.

Thanks for ALL the help so far!~~ Hopefully I can get this fixed and give you all the credit you deserve.

SSJpn

 

[CCLINT]

Even though that(changing the folder for the temp files) should not make a difference, run the update again and let it put everything where it wants
(use the defaults)

Ok. Start a new project (to see if where the problem may be) and add the Data Control to it.

What is in the Connect property now? [/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}

 

[vb5prgrmr]

Inside of the folder or your choice there should be a setup.exe or a setup5.exe. You need to run that before the SP is applied.

Good Luck

 

[CCLINT]

dum de dum dum....good catch vb5prgrmr [/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}

 

[SSJpn]

YEEEEEEEEES!!~~ I ran the setup5.exe and it works like a dream. Thanks all for your help!~~

Special Thanks
-vb5prgrmr
-CCLINT
-johnwm

 

[vb5prgrmr]

CCLINT, thanks...