hi,

I got the root cause for this problem. the recordset.reccount property doensn't work with adopendynamic with Access Database. I use adopenkeyset it works fine and returns number of records as i wrote code before.