The full error msg is..<BR><BR>Provider error '8007000e' <BR><BR>Not enough storage is available to complete this operation. <BR><BR>Basically I'm displaying an html table populated with data that meets my Querystring if the check box is "on" then do the loop for all that are checked. thing is there are over 300 results to be looped. Eack loop updates one table and adds a new record to another table.
I checked www.msdn.microsoft.com on this error and 8007000e is also listed as meaning "out of memory". How are you doing your inserts and updates? If you are using recordsets, then I would recommend switching to insert and update statements. If you are enclosing all 300 procedures within a transaction, then remove the transaction.<BR><BR>If you want more help, be a little more specific and post some code. (But, don't go overboard and post 7 pages of code, PLEASE!! Just the relevant part where we can see the entire cycle you are going through.)<BR>