Log in and password using VB6 and Access 2007

I'm trying to create a VB6 application linking to Microsoft Access 2007. I'm going to save account names and passwords in Access 2007. I'm using V开发者_StackOverflowB6 as the front end. Would somebody help me on the connection string and the codes to store and check the account names and passwords.

Have a look at this link

login form connecting to ms access

EDIT

Then how about

Asking for code design advice: working with VB.Net and Ms-Access

should help as well.