you still have not provided the error message, however looks like you need to count the number of records returned and if zero, not proceed.
Code:
if ssprst.recordcount>0 then 'continue
else
msgbox "no records"
end if
you may have to movelast in order to get the recordcount, otherwise it might return -1
however you are not disconnecting the recordset. All you have is something which is effectively the same as DAO but with less flexibility and more complexity. It certainly won't prevent corruption if your db is not split and/or all users are using the same front end.
As with Colin, this is the wrong way to go so I'll leave you to continue in that direction. Good luck with your project