1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

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,276
    Likes Received:
    364
    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