Ta Love the sarcasm :). Seriously,I am trying to acertain if this is a common problem which I have to live with. The table is created by the same page with a "unique" name held inthe variable results<BR>byesql="DROP TABLE " & results<BR>and as I said sometimes it works sometimes it doesn't<BR>read the books brought the tee shirt but still no resonable answer
Hmm, can't say that I've had something similair ever. Do you have errors/warnings in the connection.errors collection?<BR><BR>You can check this by Response.write connection.errors<BR><BR>Do you do 'other' stuff with the variable 'results'?<BR><BR>What is the exact problem? Does the table still exists, or is is dropped partial?