1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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,283
    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