Hi All, i use ‘Microsoft ActiveX Data Objects 2.7 Library’.Connection and ‘Microsoft ActiveX Data Objects 2.7 Library’.Recordset to Connect to a MySQL-Database. The Connection is not the Problem and i can select certain records of a table. But if i search for a record, which does not exist in the table an error appears. But i do not want to have an error-message. I want to catch this situation in my Code. I have tried it with “recordcount”, but this allways returns -1. And the Find-function has no return-value. How can i solve this??? Thanks in advance. Regards, Frank

Have you tried the approach from

check for recordset.Eof and Recordset.bof It is similar to recordvariable.find(’-’) and recordvariable.find(’+’) Regards