Subject ADORowset From Mustansir Ghor <mustan31@hotmail.com> Date Fri, 30 Oct 2020 10:17:06 -0400 Newsgroups dbase.getting-started Dear All The rowset that i have been using so far with BDE had properties that with ADOrowset needs to be redesigned. Among them are 1. Indexname - This had main advantage of using with findkey() method. Alternatively the solution will be to use parameter query. 2. lockset() - This was mainly used to assigned document no may be Receipt no for a shared table so that a number can not be assigned to multi users who may try to insert records simultaneously.  I wonder how this can be handled in ADOrowset 3. I understand the concept of temporary tables which can be alternative solution to local tables that required to emptied for a new form that records entries. While I design form, I create a query and datalink to grid. Then on form open I deactivate the query, empty the table and activate the query again. So if I apply same procedure for ADOquery will it refer to same table that I will create as temporarily table when I open the form. I would appreciate any help on this. And Many thanks to Akshat for his guidance on the subject Regards Mustansir