OK to continue hashing this out. I uncommented some more and it fails at this point. When trying to open and insert a new record into the tbl_Disks. It is saying it's in use but it isn't.

Open disks recordset -2147352567: COM exception error "Open" (ADODB.Recordset -
Operation is not allowed when the object is open.) [-2147352567/80020009]