unreconizable database format

[crater]

hello
I have created a Access database
now I use the vb6 form wizard to incorperate the database and it gives me this error unreconizable database format. However if I use the either sample db "Nwind or BiBlio" it will work
any ideas I have read that I might have to update the MDAC whatever that is. and I tried updateing Jet 4 sp8 and pc said I had a newer version already so that I did'nt need to update anyhow.

[RobDog888]

First, make sure your database is not corrupted. If you can manually open t in the Access GUI then its ok. If not then its corrupted and you need either a backup copy or try to repair it using Access' Repair database menu item.

[crater]

First, make sure your database is not corrupted. If you can manually open t in the Access GUI then its ok.

yes it opens in access

[RobDog888]

Then you may not have the proper MDAC installed. You can download the "Component Checker" utility from microsoft. it wll tell you which version you have, if any. Then depending on the version found you may have to download and install the newer version.

[brucevde]

The data form wizard only supported Access 97 when first introduced. You need to install Service Pack 4 or one of the other fixes found here.

FIX: The Data Form Wizard May Not Open an Access 2000 Database

[crater]

Ok I believe that you have found the prob bruce. thanks , but service pack4 for what? I'm running windows XP; office XP (which has Access 2000 attached) so I running Access 2000. Is there a service pack for office?

RobDog: I'll have to check the MDAC

bty I tried the work-around Bruce but I stupid and could'nt get it to connect to mdb either.

[brucevde]

From the Microsoft KB article I posted.

This is a problem with Visual Basic 6.0 Service Pack 3 and earlier versions. This problem has been fixed in Service Pack 4 for Visual Basic.

[crater]

sorry for not reading the complete article

anyway there is a service pack 6 out for Visual basic that I am d/l now hopefully the fix is included.

bty is the data form wizard not quite such a good idea to use anyway? It seem that if I design my own form I would get more control. but i really don't know yet because of error.

Thanks for pointing me in the right direction

[crater]

also @ Robdog I have MDAC 2.8sp1 installed
are these the lastest files available?
MS Support site says they are I think.