problem with MS office versions..?

Question

im trying to link a 2003 acces database with vb 6...i get this problem
unrecognized database format "xxx.mdb"...but when i opened a database named biblio in the miscrosoft visual studio folder it opened..i think that database was in ms access 2000 format...so is ms access 2000 compatible with vb6? and ms access 2003 not compatible with vb 6? is there a way i can convert a 2003 database to a 2000 ms access database??pls help me your help would be very much appreciated..

Answer 1

you have to convert your ms access to prior version because it's not compatible to do this open you ms access file in your ms access (of course)

1. Click Tools

2. Click Data base Utilities

3. Click Convert Data base

4. Click the version ( I rather prefer the 97 version).



hope that solve your problem

Answer 2

You have to use the proper connection string for the database you're opening. Access mdb files can't be downconverted, only upconverted. But you can connect to a 2003 mdb file with VB6 - I do it all the time.

Answer 3

I'll take an example of powerpoint. Open the presentation in 97 to go "save as". below the file name there are list of options. select 95 and save the file. you will be open this file using lower versions.