"Unrecognized data base format"

[Stuart Grant]

I can no longer find a VB6 group so am asking the question here since it
concerns an Access database in the hope that an expert here knows the source
of the problem.

I have gone back to a program I started writing - but never finished a
couple of years ago. It uses a data base Winvesta.mdb. In the program
there is a menu command 'Display Master List'. When I click this I get an
error message - "Unrecognized data format 'C:\SAGProgs\Winvest\Winvesta
mdb". If I press the Help button, I get "Help 'Item? (Error 524) The
specified error has occurred in the automation object currently running".

I don't understand what is wrong. If I click on Winvesta.mdb in the
directory specified, it starts at once in Access and displays the Master
table if required. The form in the program has two command buttons and an
ADO data control. I have checked all the properties but can find nothing
wrong. The data source is given exactly as in the error message. There are
no typos.

Does anyone know what must be wrong ?

Stuart

 

[Pieter Wijnen]

It can be that you'r program references an older version of DAO (3.51,
Access '97) & that you've accidently upgraded the database to DAO (4.0,
Access2000+), You can then either downgrade the db or upgrade your
reference.

HTH

Pieter

 

[Guest]

Hi Stuart,

Have you applied all of the service packs for your installation of VB6? The
original release could not read JET 4 databases. Here are a couple of KB
articles that you may find helpful:

http://support.microsoft.com/kb/257780
http://support.microsoft.com/kb/238401


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Stuart Grant]

Pieter

You are right. I must have started the program when I was still using
Access 97. Since then I upgraded the database as I now have Office 2003 and
have worked with the database in Access 2003.

I still had problems finding the reference. It is not obvious !! It is of
course the Connect property of the ADO control,. I changed this value to
Access 2000. No more problems.

Thanks again for the prompt help.

Stuart

"Pieter Wijnen"

 

[Stuart Grant]

Tom

Thanks for your help. Pieter was right. I still had the Connect property
of the ADO control as Access and not Access 2000, although I had upgraded
the database.

I'm not sure I have all the updates for VB6 so will check the KB articles
you mention.

Stuart

 

[Douglas J. Steele]

You've got an answer to your question, but I thought I'd point out that all
of the microsoft.public.vb.* newsgroups are VB6 (or lower).

If you can't find them on your newserver, use msnews.microsoft.com

 

[Stuart Grant]

Douglas

I DO use msnews.microsoft.com but don't find any microsoft.public.vb groups
there.

What I am I doing wrong ? I find about 70-80 groups but none about VB

Stuart

 

[Douglas J. Steele]

I see 36 groups starting microsoft.public.vb.

I see you're using Outlook Express. Try selecting Tools | Newsgroups from
the menu bar (or use Ctrl-W), then reset the list.