[priya2345]

Hello,

First of all thanks to all who have answered my previous post

In my project I am using MS-ACCESS version 2000, VB 6 and Crystal Reports 8.5

In VB I am not able to connect to access databases of version 2000 using the data control or ADO . I gives error "unrecognized database format".
If I convert the MS-Access Database to 97 format then it works but the message says that i may not be able to change the design of the tables.

IS THERE ANY REFERENCE IN VB TO USE HIGHER VERSIONS OF MS-ACCESS DATABASE like 2000, 2002 USING DATA CONTROL.

So I started using DataEnviornment to connect to the databases in 2000 format and it works well. How come it connect successfully with Data enviornment. While connecting i use microsoft jet 4.0 provider

Now my problem is I added a DBCombo and want all the product names from Product table in the combo list, and bound the column productno. But using Data Enviornment i am not able to set the Recordsource property for DBcombo. its possible with data control, but as I said I can't connect with the 2000 format database using data control.

Thanks again to all

[PsychoCoder]

You need to post the code you're using to connect to the database in order for us to help, we cant help if we cant see what you're doing.

[priya2345]

I got the solution. Since VB 6 was introduces before Office 2000, the data control was not supporting it. I installed Visual Basic 6 Service Pack from Microsoft website. Now I can access through data control

This post has been edited by priya2345: 08 September 2007 - 01:27 AM