I have figured out my problem. I am using free tables with no dsn. The problem turned out to be a security issue the IUSR account had rights to the files but it also needed th IWAM account to have access rights
Thank you to all for your help..