database connectivity

[lee123]

i have made a databse in access 2000 and when i try to use the data control and try to connect it tells me that "unreconize d database format" why does it say this i thought you could connect to any database in access even the ones you have already built the vb im using is vb6 in my database i have made it a replicated one could this be a problem or you just have to make your own database through vb6 and not in access.....

lee123

[fplesco]

i have made a databse in access 2000 and when i try to use the data control and try to connect it tells me that "unreconize d database format" why does it say this i thought you could connect to any database in access even the ones you have already built the vb im using is vb6 in my database i have made it a replicated one could this be a problem or you just have to make your own database through vb6 and not in access.....

lee123

Hi Lee -

How did you bind your Access dbase with the data control? Can you tell me?
Or if possible, can you put part of the code here?

FYI. I also got that error before and it seemed to me that that I have used the wrong object in connecting with my database. second, I have used the wrong Driver for my database.

You may check if you have used the Jet.4.0 something driver of the Access database, not the Jet.3.5.

[lee123]

well i tried to use the data control but it wouldn't do anythig and thats when i got that message then i also tried the ado data control and that clearly didn't work. i have looked at the questions they have here on the scripted and found one by a yoda person but i didn't understand what they did about the data control are you suppose to put somekind of code behind it and if so how.... if you could tell me the basic way i probably can figure out the rest any way i have built this database in access 2000 and i used it at my job but this seemed to be a cooler way to go i guess i don't know if you can help me figure out this i would appriciate it...

lee123

[pureenhanoi]

i have made a databse in access 2000 and when i try to use the data control and try to connect it tells me that "unreconize d database format" why does it say this i thought you could connect to any database in access even the ones you have already built the vb im using is vb6 in my database i have made it a replicated one could this be a problem or you just have to make your own database through vb6 and not in access.....

lee123

Some old version of Data Control cannot work with Access2000 format. You must use Data Conversion Ultility in Ms-Access to convert your database into Access 97 format before bind the data to DataControl

[lee123]

well i tried to format the database to access 97 but when it asked me to format as i put access 97 but it said couldn't format this database there was an error mayby i didn't do it right because i went to th help file and see how you format it back to 97 and i did just what it said to do and still i got the same message

lee123

[miroku800]

Dont know if this could be the answer but I had a problem very similar and I discovered that my version of VB6 required service pack 1 before it would utilise databases properly.
I only discovered this as a program written at work was fine but the same program at home had the problem and by comparing both setups found that work had been serviced packed and mine hadn't

Just a thought which could be totally wrong but worth a look

Hope it helps Rob

[pureenhanoi]

Dont know if this could be the answer but I had a problem very similar and I discovered that my version of VB6 required service pack 1 before it would utilise databases properly.
I only discovered this as a program written at work was fine but the same program at home had the problem and by comparing both setups found that work had been serviced packed and mine hadn't

Just a thought which could be totally wrong but worth a look

Hope it helps Rob

I rerally use Data Control, so i dont know can Service Pack 1 update DataControl to newer version. If you have the SP1, you can try updating.
Converting database to Access 97 file format cause the database un-editable (i dont know why - i've do like this before in Office Xp and it works fine, but now i'm using office 2003, and it make database un-editable). Ofcourse, you cant edit the database's object (like table, form, report ...) but still can insert, update and delete the data. Thats enought.

[lee123]

well my question is how do you format the access 2000 database to a access 97 ive tried but when it takes me to a page that says: convert in to what? what is it i put for the file name the database name or "access 97"
lee123

[pureenhanoi]

well my question is how do you format the access 2000 database to a access 97 ive tried but when it takes me to a page that says: convert in to what? what is it i put for the file name the database name or "access 97"
lee123

Open MS-Access , from main menu, choose Tools > Database Ultilities > Conver Database > To Access 97 file format.
On the dialoge, browse to the access file in 200 file format and click Select.
On the dialoge Conver database to, type the name for the new file (which will be in 97file format), and click Save. If you Save new database in the same folder with old database, use the diffent name from the old database.
Access will show a dialoge that caution: Some Function of database will be lost. Click Ok. Now, you have the datafile in Access 97 file format.

[lee123]

well mine doesn't say convert to access 97 it just says convert to previous database. do you think that it the office software i'm using because i'm using microsoft office 2000 premium i bought the office 2000 developers tool kit
but i do have a office 2000 regular disk should i change softwares?

lee123

[pureenhanoi]

well mine doesn't say convert to access 97 it just says convert to previous database. do you think that it the office software i'm using because i'm using microsoft office 2000 premium i bought the office 2000 developers tool kit
but i do have a office 2000 regular disk should i change softwares?

lee123

I'm using Office 2003, and it say exactly: "To Access 97 file format". Dont mind about this. Previous file format of Access200 is Access97 file format. You may should read the help content to find out the best way of converting.
After all of this complexibility problem, wouldnt you give up using Data Control?
There are many ways of using database without Data Control. You cant try them and compare the complexible.