The "good" way to use .Recordset "H. Martins" <HJRMartins[ at ]gmail.com> 12/11/2008 11:50:55 AM I have done sore database editing using Dim rs As DAO.Recordset .... Set rs = DBEngine(0)(0).OpenRecordset(strSelect) .... but I have also used some different methods, ie, some different resources. I got used to this one just because I had some more unsolved difficulties with the other alternative ways I tried. I would jut like to know if the above is a acceptable way of doing thing, if it is not, eventually, some obsolete method. Thanks H. Martins

Re: The "good" way to use .Recordset "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_gmail.com> 12/11/2008 12:48:17 PM That's a valid approach. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "H. Martins" <HJRMartins[ at ]gmail.com> wrote in message news:db30f05b-0c44-4e93-b18a-a51479684fe0[ at ]z27g2000prd.googlegroups.com... [Quoted Text] >I have done sore database editing using > > Dim rs As DAO.Recordset > ... > Set rs = DBEngine(0)(0).OpenRecordset(strSelect) > ... > > > but I have also used some different methods, ie, some different > resources. I got used to this one just because I had some more > unsolved difficulties with the other alternative ways I tried. > > I would jut like to know if the above is a acceptable way of doing > thing, if it is not, eventually, some obsolete method. > > Thanks > > H. Martins > >