Connect to access database

Discussion in 'Visual Basic ( VB )' started by ndakota, Sep 22, 2007.

  1. ndakota

    ndakota New Member

    Joined:
    Aug 9, 2007
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    0
    Sir,
    My room partner and i are making a project named 'online examination' in which we require to connect to access.
    we are planning to get questions from records in access files.
    but i don't know how to fetch records from access tables.
    can you please help me.
    i know it is not possible to learn database connectivity in a single answer.
    but if you can suggest some methods, it will be helpful.
    Also if you can suggest another way to get questions in the forms, please suggest.
    Thanks a lot!
    NdAkOtA
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    Code:
    Select * from Questions
    should give you all the questions from the Questions table. Instead of going for such questions I would suggest you get hold of some books or an e-book at least.
     
  3. vishalhak

    vishalhak New Member

    Joined:
    Nov 22, 2007
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    create a table that contains the different fields of the database, eg: question, option1,option2....,correct answer
    In VB , create a function searching for the condition the the answer given by the user is correct or not
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice