Essentially what you want to do is create an array of images and hide them off the form to start.

Now on load or on push of a button simply run a rand() function and call to array image[x]
...

Store the database on:

\\yourserver\yoursahrename

Now make the adjustments in VB6 program to call the correct path.

Apply the correct permissions for your users to allow access to the db.
...

Make sure that you define these variables integer based.

it might be doing a text comparison because of data type.

Store the variables into a temp var that is defined as integer and then run...

I rest my case.... :cheesy:

Why not just do this in sql?

Ok First off:

http://www.microsoft.com/downloads/details.aspx?FamilyID=6C050FE3-C795-4B7D-B037-185D0506396C&displaylang=en


Second..
Add these librarys in your project
Microsoft Activex Data...