Retieving Data of MS Access by VB6?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • vbuser333
    New Member
    • Apr 2007
    • 2

    #1

    Retieving Data of MS Access by VB6?

    I am creating a book store system with VB 6. I have four interfaces and in the database I save information about books and companies in 2 tables. In the book table my fields are - Book Name, Stocks, ISBN & in the other my fields are -Company Name , Address. But I cannot create a primary key. Help me there plase!
    And also i want to know the codings to retrieve the saved data of the tables. Anyone of you know? Please reply!
  • cuteanu
    New Member
    • Oct 2006
    • 14

    #2
    Ms Access provides the facility to form the primary key, there is a key icon in the tool box, and then in the relationships menu, relation between both the tables can be formed.
    To retrive data into VB, VB should be connected to Ms access, you can do it by many ways.

    Comment

    • Dököll
      Recognized Expert Top Contributor
      • Nov 2006
      • 2379

      #3
      Originally posted by vbuser333
      I am creating a book store system with VB 6. I have four interfaces and in the database I save information about books and companies in 2 tables. In the book table my fields are - Book Name, Stocks, ISBN & in the other my fields are -Company Name , Address. But I cannot create a primary key. Help me there plase!
      And also i want to know the codings to retrieve the saved data of the tables. Anyone of you know? Please reply!
      Hey there vbuser333

      I got just the thing, but if this is a school project I need to know where you are, any coding measures already taken in order to attempt coaching.

      You can also fetch this forum a bit deeper, a number of tips should and will pop up. I find this to be helpful...

      Good luck with the project!

      Oh, I would also suggest starting with one table, make it work with VB then move on to the next (cut an paste existing code for other tables)...

      Dököll
      Last edited by Dököll; Apr 29 '07, 01:27 PM. Reason: Added remark

      Comment

      • vbuser333
        New Member
        • Apr 2007
        • 2

        #4
        Well, hi. yeah mine is a school project. I need a tutor to teach me how finish this coding. I already did designed all the interfaces. I know how to code exit,clear, save and linking other forms but retrieving data from a MS Access is difficult. Will youhelp me? please.

        Originally posted by Dököll
        Hey there vbuser333

        I got just the thing, but if this is a school project I need to know where you are, any coding measures already taken in order to attempt coaching.

        You can also fetch this forum a bit deeper, a number of tips should and will pop up. I find this to be helpful...

        Good luck with the project!

        Oh, I would also suggest starting with one table, make it work with VB then move on to the next (cut an paste existing code for other tables)...

        Dököll

        Comment

        Working...