VB 6.0 with Office 2000 - Access version

[yagnik3128]

I am using VB 6.0 and want to connect Access Database through DSN or ADO. But if MDB file is created in OFfice 2000 - access version. It is showing me the error - Unable to open Database format.
Help me.

 

[sunaj]

Hi,

I'm Using VB60 with office 2000 (NT) and don't have any problems.

- You must use ADO to access the database (Cannot use DAO).

- Make sure that you have a new version of ADO (2.5 or 2.6)

Sunaj

 

[yagnik3128]

Yes I am using ADO instead of DAO,
I added Microsoft Activex Data Object 2.0 library through Project references.

Where can i get 2.5 or 2.6 ADO version ??

 

[sunaj]

http://www.microsoft.com/data/download.htm

 

[Guest_imported]

You can use microsoft oledb4.0 for ADO.
For DAO you should use DAO 3.51 object library from References of project menu. I hope you will get the solution.

 

[yagnik3128]

Hi !mamunal
I am not getting u. I didn't find any microsoft oledb 4.0 for ADO in references

If u can explain me in detail.

 

[Guest_imported]

no, you cannot seee it at references. If you use ADODC than you can select it when you want to connect through it's property.
Another soln is that
dim cn as new adodb.connection

cn.open "provider=microsoft.jet.oledb.4.0.;data source=dbname.mdb;"
this way you can try.
thank you

 

[MikeBronner]

Mamumal is correct. I have set up an extensive database-driven application using that method. Then to further access the db, you can use SQL queries to perform actions. Best Regards and many Thanks!
Michael G. Bronner X-)

"The problem with the world is that everyone is a few drinks behind." Humphrey Bogart

 

[Guest_imported]

another soln is that you can convert the database to it's previous version from Access (in menu bar Tools then Database Utility then convert to prevous version). The problem will also be solved with this way.

 

[manisa]

I have try to convert database to previous version . it can solve the error but we can't edit a data in a field.

Am I right ?


....try from below...


T.k

 

[Rogg]

Install Service Pack 4 for Visual Basic 6. SP4 supports the new file formats for Access 2000.

 

[yagnik3128]

Hi Rogg,

I got the service pack 3 for Visual Studio & my problem is solved

Thanks for help.

Yagnik