Visual Basic frontend configuration database access

[-ian-]

I would like to port my access application to having a visual basic frontend with Access at the back.

My motivation is that I want to learn how to connect from Visual Basic to Access, and possibly one day SQL server.

Its a lot out of my league, and I don't know where to start. I have Visual Basic 6, and don't know how to go about setting up the connection in the code.

Could someone get me started here?

 

[-ian-]

Thanks Pat. Sorry to have posted here, but thanks -you gave me enough info to do an intelligent web search.

For anyone other novices that need a leg up in using VB to connect to their access database here's the link I found.

http://www.visualbasicforum.com/showthread.php?s=&threadid=11273