you are going about it the wrong way. when someone selects a record to edit, you pass an id, or other identifier for the record, to the other page via a querystring, cache object, varaible, etc. Then you open a new connection to the databse using an sql statement that gets the record. You NEVER ,,,EVER keep a database connection open across pages. Do not even attempt to keep finding out how as any good programmer will tell you the same thing.