VS 2008 How to connect Vb 2008 to Ms access 2007-VBForums
Results 1 to 16 of 16

Thread: How to connect Vb 2008 to Ms access 2007

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Mar 2010
    Posts
    67

    How to connect Vb 2008 to Ms access 2007

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

  2. #2
    Fanatic Member
    Join Date
    Dec 2009
    Posts
    595

    Re: How to connect Vb 2008 to Ms access 2007

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

  3. #3
    Addicted Member garyjohn_2000's Avatar
    Join Date
    Apr 2005
    Location
    Timbaland
    Posts
    243

    Re: How to connect Vb 2008 to Ms access 2007



    Anyone who has never made a mistake has never tried anything new. - Einstein
    Peace!

  4. #4

    Thread Starter
    Lively Member
    Join Date
    Mar 2010
    Posts
    67

    Re: How to connect Vb 2008 to Ms access 2007

    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)....

  5. #5
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    86,068

    Re: How to connect Vb 2008 to Ms access 2007

    Quote Originally Posted by vb6beginer View Post
    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.

    2007-2014

    Why is my data not saved to my database? | MSDN Data Walkthroughs
    MSDN "How Do I?" Videos: VB | C#
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts) | WP8 Turnstile Feather Transition with Pivot Control
    Beginner Tutorials: VB | C# | SQL

  6. #6

    Thread Starter
    Lively Member
    Join Date
    Mar 2010
    Posts
    67

    Re: How to connect Vb 2008 to Ms access 2007

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

  7. #7
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    86,068

    Re: How to connect Vb 2008 to Ms access 2007

    Quote Originally Posted by vb6beginer View Post
    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.

    2007-2014

    Why is my data not saved to my database? | MSDN Data Walkthroughs
    MSDN "How Do I?" Videos: VB | C#
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts) | WP8 Turnstile Feather Transition with Pivot Control
    Beginner Tutorials: VB | C# | SQL

  8. #8

    Thread Starter
    Lively Member
    Join Date
    Mar 2010
    Posts
    67

    Re: How to connect Vb 2008 to Ms access 2007

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

  9. #9
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    86,068

    Re: How to connect Vb 2008 to Ms access 2007

    Quote Originally Posted by vb6beginer View Post
    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.

    2007-2014

    Why is my data not saved to my database? | MSDN Data Walkthroughs
    MSDN "How Do I?" Videos: VB | C#
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts) | WP8 Turnstile Feather Transition with Pivot Control
    Beginner Tutorials: VB | C# | SQL

  10. #10

    Thread Starter
    Lively Member
    Join Date
    Mar 2010
    Posts
    67

    Re: How to connect Vb 2008 to Ms access 2007

    can i able to connect vb6 with ms access 2007?

  11. #11

    Thread Starter
    Lively Member
    Join Date
    Mar 2010
    Posts
    67

    Re: How to connect Vb 2008 to Ms access 2007

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

  12. #12
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    86,068

    Re: How to connect Vb 2008 to Ms access 2007

    Quote Originally Posted by vb6beginer View Post
    can i able to connect vb6 with ms access 2007?
    Of course, but you'd have to ask about that in the VB6 forum.

    2007-2014

    Why is my data not saved to my database? | MSDN Data Walkthroughs
    MSDN "How Do I?" Videos: VB | C#
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts) | WP8 Turnstile Feather Transition with Pivot Control
    Beginner Tutorials: VB | C# | SQL

  13. #13

    Thread Starter
    Lively Member
    Join Date
    Mar 2010
    Posts
    67

    Re: How to connect Vb 2008 to Ms access 2007

    k thank you

  14. #14
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    86,068

    Re: How to connect Vb 2008 to Ms access 2007

    Quote Originally Posted by jmcilhinney View Post
    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.

    2007-2014

    Why is my data not saved to my database? | MSDN Data Walkthroughs
    MSDN "How Do I?" Videos: VB | C#
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts) | WP8 Turnstile Feather Transition with Pivot Control
    Beginner Tutorials: VB | C# | SQL

  15. #15

    Thread Starter
    Lively Member
    Join Date
    Mar 2010
    Posts
    67

    Re: How to connect Vb 2008 to Ms access 2007

    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?
    Attached Images Attached Images

  16. #16
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    86,068

    Re: How to connect Vb 2008 to Ms access 2007

    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.

    2007-2014

    Why is my data not saved to my database? | MSDN Data Walkthroughs
    MSDN "How Do I?" Videos: VB | C#
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts) | WP8 Turnstile Feather Transition with Pivot Control
    Beginner Tutorials: VB | C# | SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.