I am planning on making a registration program, but i would like it use a database to see if it has been activated before.

I have a database with these fields:
RegID, PID (Primary key), Activated - the Activated field is Yes/No

On activation if the PID isn't there i want to add it, and set the Activated to Yes. If the PID is there and Activated = Yes, it will not activate the program.
If the PID is there and Activated = No then it will activate and set Activate to Yes.

I am going to use a Access Database on a server, the thing is i dont have a clue how to use a database with vb6.

First of all i would like to know how to connect to a password protected database on a remote server.

Thanks in advance