Using MSACCESS

Dear friends,
First of all plese let me inform you that I have started learning VB and Access just a few days back so kindly bear with my shallow knowledge.
Also I am new to this forum.

Actually I want to make a software where data is picked up from an MSACCESS file and then selectively picking data from that file reports have to be generated.

So I started reading this book by Eric A. Smith, VB6 Bible.

There I came across the chapter which explains using MDI Forms. He has explained how to connect to a database. But the database is ACCESS 97 format and I am having Office XP. When I compile the codes written it gives me and error saying
"Runtime error 3343"
Unrecognized database format.

Could someone help me solve this problem

Thanks for your help.

Comments

  • : Dear friends,
    : First of all plese let me inform you that I have started learning VB and Access just a few days back so kindly bear with my shallow knowledge.
    : Also I am new to this forum.
    :
    : Actually I want to make a software where data is picked up from an MSACCESS file and then selectively picking data from that file reports have to be generated.
    :
    : So I started reading this book by Eric A. Smith, VB6 Bible.
    :
    : There I came across the chapter which explains using MDI Forms. He has explained how to connect to a database. But the database is ACCESS 97 format and I am having Office XP. When I compile the codes written it gives me and error saying
    : "Runtime error 3343"
    : Unrecognized database format.
    :
    : Could someone help me solve this problem
    :
    : Thanks for your help.
    :
    Hi!

    If I understood you well...

    Try to convert the database to Access 2002 version...
    In Access:
    Tools->Database utilities->Convert database->To Access 2002 File Format

    Greetings from Gogi!
    :

  • Thanks for your help Gogi

    I have solved that problem I suppose. I managed to get MSAccess 97.
    But now when I compile the program written it gives me the following error
    "Runtime Error 13"
    Type Mismatch.

    On pressing debug, it takes me to the following line
    ctlListView.ColumnHeaders.Add "Column" & i, rsListData.Fields(i).Name

    Could you please tell me what is wrong with this line.

    Thanks again for your help.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories