How to connect Vb 2008 to Ms access 2007

[vb6beginer]

Hi,
Can i connect MS access 2007 to VB 2008? Pls help me out on this..Thanks in advance...

[Tommy.net]

can you tell whet you have tried yet so can i can help you?

[garyjohn_2000]

MSDN Data Walkthrough: Connecting to Data in an Access Database

[vb6beginer]

i tried using connection using ADODc control as we can do in vb6....but when i right click adodc control and click the properties...the property page of this control is not displayed(this is working well in vb6)....

[jmcilhinney]

i tried using connection using ADODc control as we can do in vb6....but when i right click adodc control and click the properties...the property page of this control is not displayed(this is working well in vb6)....

You're not in VB6 anymore Toto! You're using VB.NET now, so you should use it. ADO.NET was designed from the ground up for data access in .NET apps. The only reason to not use ADO.NET is that you're upgrading an existing VB6 app that already uses ADO. If that's not the case, use ADO.NET.

[vb6beginer]

k fine...tell me how to do that..

[jmcilhinney]

k fine...tell me how to do that..

Um, did you follow the link provided in post #3?

There are various ways you can access the same data and the way you choose depends on circumstances and personal preference. You might follow the Database FAQ link in my signature and check out some of the ADO.NET resources there for the more manual way to go. The previous link uses more of the IDE's in-built features and less code.

[vb6beginer]

hm.... i did as per details in that link...but its not working

[jmcilhinney]

hm.... i did as per details in that link...but its not working

Many thousands of people have used that information without issue, so you must have done something wrong. You haven't given us any information about what you did or what happened when you did it so there's no way we can help you.

[vb6beginer]

can i able to connect vb6 with ms access 2007?

[vb6beginer]

can i able to connect vb6 with ms access 2007? pls reply

[jmcilhinney]

can i able to connect vb6 with ms access 2007?

Of course, but you'd have to ask about that in the VB6 forum.

[vb6beginer]

k thank you

[jmcilhinney]

Many thousands of people have used that information without issue, so you must have done something wrong. You haven't given us any information about what you did or what happened when you did it so there's no way we can help you.

By the way, the implication there was not that we can't help you at all, but that we can't help you without any information. If you were to show/tell us exactly what you did and exactly what happened when you did it, then we could help you fix it. Things don't just not work, so you need to provide us with information so that we can diagnose the issue, just like a doctor would need information to diagnose an illness or mechanic diagnose a problem with your car.

[vb6beginer]

the file that i attached is the needs of my project to do...i finished student score form and add new student form....what i need to do is that in the update student score form i want to retrieve the score value from the database to the listbox...in the add new student from i get the scores in label and i stored that in database.now i want these scores to be listed in the listbox in update student score.......so i thought to have multivalue in scores field in the database table.but multivalue is possible in access 2007,and somebody told that we cant connect access 2007 file to vb6...so i thought to change to vb 2008 so that i can connect access 2007 to vb 2008 for doing my project....
so now help me on this pls...how should i proceed further?

[jmcilhinney]

VB6 can connect to any OLEDB data source. If you want to connect to an ACCDB file, which is Access 2007 format, then you'll need the ACE OLEDB provider installed. That goes for VB6 apps and VB.NET apps. The ACE provider is installed along with Access 2007 or it can be downloaded as part of the Office Driver Pack.