1 Reply Latest reply on Aug 1, 2006 11:22 AM by Newsgroup_User

    Re: Read Only

    Level 7
      i did and had this reply

      The second thing you should do is try to minimize the number of JET*.tmp
      files you need to create. For example, when opening the database solely to
      retrieve data (no UPDATE, INSERT or DELETE), do so in adModeRead mode. This
      way, Access will use the least amount of temporary files, since it doesn't
      need to prepare room or logic for changing existing data. Here is an example
      of opening an Access database in adModeRead mode:

      eg

      <%
      set conn = CreateObject("ADODB.Connection")
      conn.mode = 1 ' adModeRead
      conn.open "<connection string>"
      ' ...
      %>

      How do i open the database in adModeRead within dreamweaver


        • 1. Re: Read Only
          Level 7
          Add that code to the top of the page?

          How big is your database? How many records? What kind of use is it
          getting?

          I have never heard of this stuff before, but then I am only a casual
          user....

          --
          Murray --- ICQ 71997575
          Adobe Community Expert
          (If you *MUST* email me, don't LAUGH when you do so!)
          ==================
          http://www.dreamweavermx-templates.com - Template Triage!
          http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
          http://www.dwfaq.com - DW FAQs, Tutorials & Resources
          http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
          ==================


          "Andrew Harris" <andrew.harris@hotmail.co.uk> wrote in message
          news:eao5nj$bmc$1@forums.macromedia.com...
          >i did and had this reply
          >
          > The second thing you should do is try to minimize the number of JET*.tmp
          > files you need to create. For example, when opening the database solely to
          > retrieve data (no UPDATE, INSERT or DELETE), do so in adModeRead mode.
          > This way, Access will use the least amount of temporary files, since it
          > doesn't need to prepare room or logic for changing existing data. Here is
          > an example of opening an Access database in adModeRead mode:
          >
          > eg
          >
          > <%
          > set conn = CreateObject("ADODB.Connection")
          > conn.mode = 1 ' adModeRead
          > conn.open "<connection string>"
          > ' ...
          > %>
          >
          > How do i open the database in adModeRead within dreamweaver
          >