Dear All,
I created a database in MS-Access 2000 mdb as 2000 file format. When I
open it in VB 6.0 at Add-ins --> Visual Data Manager, it gives message
'Unrecognized database format'. I already applied vb6.0 sp5. My all
data is in this mdb. I also want to create form thru Visual Data
Manager. If anybody has solution, please reply. Thanks in advance
Ralph - 24 Jun 2006 20:26 GMT
> Dear All,
> I created a database in MS-Access 2000 mdb as 2000 file format. When I
> open it in VB 6.0 at Add-ins --> Visual Data Manager, it gives message
> 'Unrecognized database format'. I already applied vb6.0 sp5. My all
> data is in this mdb. I also want to create form thru Visual Data
> Manager. If anybody has solution, please reply. Thanks in advance
http://www.devx.com/vb2themax/Tip/18535
plus a couple of dozen other ones, just google "unrecognized database format
vb6 ms access"
Make sure you have the latest Jet for your platform.
http://msdn.microsoft.com/data/ref/mdac/downloads/
As while using the IDE data tools use the "Remote" option. You can can
always go back into the code and make any adjustments.
hth
=ralph
Paul Clement - 26 Jun 2006 15:30 GMT
¤ Dear All,
¤ I created a database in MS-Access 2000 mdb as 2000 file format. When I
¤ open it in VB 6.0 at Add-ins --> Visual Data Manager, it gives message
¤ 'Unrecognized database format'. I already applied vb6.0 sp5. My all
¤ data is in this mdb. I also want to create form thru Visual Data
¤ Manager. If anybody has solution, please reply. Thanks in advance
You have to modify the Visual Data Manager since it was written to support Jet 3.51.
How To Modify the Visual Data Manager (VISDATA) to Work with Access 2000 Databases
http://support.microsoft.com/kb/q252438/
Paul
~~~~
Microsoft MVP (Visual Basic)
Sanjib Biswas - 26 Jun 2006 15:45 GMT
If you have created the database using MS Access, then you may want to look
in the Tools -> Database Utilities -> Convert Database to convert the
database to access 97 or 95 database format. But again you have to see
whether your circumstances allow you to change the database format to lower
than access 2000 version.
Regards
Sanjib
> Dear All,
> I created a database in MS-Access 2000 mdb as 2000 file format. When I
> open it in VB 6.0 at Add-ins --> Visual Data Manager, it gives message
> 'Unrecognized database format'. I already applied vb6.0 sp5. My all
> data is in this mdb. I also want to create form thru Visual Data
> Manager. If anybody has solution, please reply. Thanks in advance