>IT WORKED thank you very much. I did what you said and it worked. I am pretty new to this is there any reading material that you could reccomend.

For VBScript the VBScript Programmer's Reference from Wrox Press is good reading. Also from Wrox Press the ADO Programmer's Reference should provide you with useful knowledge.

Get the latest edition of these books because there are several of them but they will present older versions of both VBScript and ADO.