Hello,

I'm working on a program, that should be completely editable whil running. All of that (posititioning buttons, editting colors,etc) is not my question for now.

I want to connect a Database from access (2007) to my project in VB6. I tried working with queries, but somehow i can't get it to work properly.

example of my database
name: Sports
column A : ID-numbers (all unique)
column B : Sportgroup (ballsport, atletics, extreme-sports, etc)
column C : Specific Sport (for ballsport: baseball, am. football, etc.)
and some other information

What i would like to do with the program is this:
2 comboboxes
first combobox contains all from column B --> Select sportgroup
combobox 2 addapts to combobox 1 --> Select sport
Then, some information, Game Rules, Tips, etc show up


So far so good. If i want to make this a fixed program (user can't add or remove group/sport) i'd be ready by now.

What i want is that the user can add an item to the combobox, and keep it there the next time the program is started.

My questions:
Basic question = How can i connect a database to vb6?
I have no access to the northwnd.mdb file (my office blocks downloading), so that's why i could work with the tutorials i found.

How can i connect a column from an access-file to the combobox?
How can i make the 2nd combobox addapt to that one?
how can i make an additem button, writing it in the database?
and how can i make it working the second time i run the program?

thanks in advance.