Hi, May i know after i open my database, what is the code for finding the number of rows in my table?

Set MyDatabase = DBEngine.OpenDatabase("C:\temp.mdb", True)

Set rcd = MyDatabase.OpenRecordset("tbl_Main")
rcd.MoveFirst

thanks in anticipation.