Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multi-line replace ? (A2000-SR1)

    I have to convert an application from DAO to ADO, and I am looking for an easy way to replace one line of code which occurs in many modules:

    Set rst = currentdb.Openrecordset(strSQL)

    with 2 lines

    Set rst = new ADODB.Recordset
    rst.Open strSQL, etc

    I cannot get the Edit/Replace on the main menu to accept multiple lines by embedding carriage returns in the text. The long way round is to change every reference manually but as there are over 70 of them, I would love to find a quicker and easier way to do it.

    Any thoughts, Loungers ?

    Nick

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Multi-line replace ? (A2000-SR1)

    Sorry, but it isn't that simple. There's a whole lot more to converting from ADO to DAO than just replacing the code that instantiates the recordset object variable. And even after you convert that line, you still have to convert almost all the rest of your code to use ADO methods instead of DAO.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •