vb6 writing to access database

[ckarnuth]

I have a program that i have created, that has a form that the user enters information into, clicks a command button and the information is transmitted to another form for verification. on the verification form, i need it to then write the information into an access database, however I have not the slightest clue where to begin to set this up.
I have tried to use an odbc connection and had no luck. I am not familiar with the sql language at all, which is another problem that i am facing.

i have already stored all of the information as public variables, but can't get them into the database.

Any help would be appreciated. thanks in advance.

[debasisdas]

This topic has alreaady been discussed several times here in the forum. Please use the search box on top right side of the page for the same. Also check in the HowTo section for some related articles.

[ckarnuth]

Thank you, that helped, i have found the code to do what I need, however now I am experiencing another issue. when I try to run the program I get this error.

run-time error 3343
unrecognized database format

this is the code that I am using as a test, only inserting one field to make sure that it works before I code all 35 fields.

Dim My_Database As Database
    Set My_Database = OpenDatabase("C:\Users\Ckarnuth\Desktop\Auxilary Club Program\Master List.mdb")
    My_Database.Execute "insert into Master List.Members(FName) Values('" & strFName & "')"
    My_Database.Close

I am using VB6 and also running Windows Vista on my pc, don't know if that is the cause or not.

[debasisdas]

Try to convert the access file to 97 format and then use.

[ckarnuth]

Not to sound like a complete Newbie, but how do you convert the database to 97, never had to do that, so i have no clue

[debasisdas]

check the menu database utility ------> convert database.

[ckarnuth]

converted the database into a 97 format and now I am receiving a syntax error in the insert statement.

here is the insert statement.

My_Database.Execute "insert into Master List97.Members(FName) Values('" & strFName & "')"

[Patil Shankar]

please,
devl.me soft. that mscit exam demo neet by code me program

[ckarnuth]

please,
devl.me soft. that mscit exam demo neet by code me program

what, i don't understand your post ?

[lotus18]

[CODE=vb]My_Database.Exe cute "insert into Master List97.Members( FName) Values('" & strFName & "')"[/CODE]

What is List97.Members ?