how can i fix this error

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • sweetjos
    New Member
    • Mar 2010
    • 10
    #1

    how can i fix this error

    Error Type:
    Microsoft JET Database Engine (0x80040E37)
    The Microsoft Jet database engine could not find the object 'Expr1001'. Make sure the object exists and that you spell its name and the path name correctly.
    /example/guestbook.asp, line 26

    Browser Type:
    Opera/9.51 (Windows NT 5.1; U; en)

    Page:
    GET /example/guestbook.asp
    Tags: None
    • GazMathias
      Recognized Expert New Member
      • Oct 2008
      • 228
      #2
      Expr1001 is a name Access gives to a calculated field that you neglect to name yourself.

      For example if you add a field to a query that adds tax to the net amount, you would normally do "Total: [net] + [tax_amount]" in the Access Query Designer or "[net] + [tax_amount] As Total" in SQL.

      So basically, go check your queries. We can't help you any further because you have not posted any of the relevant code.

      Gaz.

        Comment

        • sweetjos
          New Member
          • Mar 2010
          • 10
          #3
          Thank you sir,
          I have another question....

          Recently I got this error.
          Error Type:
          Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
          [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
          /Jose/add.asp, line 21

          Browser Type:
          Opera/9.80 (Windows NT 5.1; U; en) Presto/2.5.22 Version/10.50

          Page:
          GET /Jose/add.asp
          My code is as follows.....

          <%@ Language=VBScri pt %>
          <% Response.Buffer = true %>
          <HTML>
          <HEAD>
          <META NAME="GENERATOR " Content="Micros oft Visual Studio 6.0">
          </HEAD>
          <BODY>
          <%
          Dim rs

          Set rs = Server.CreateOb ject ("ADODB.Records et")
          rs.CursorType = 2
          rs.LockType = 3
          rs.Open "register", "DSN=Registrati on"


          rs.AddNew

          rs("Name") = Request.Form ("name")
          rs("Age") = Request.Form ("age")
          rs.Update


          rs.Close
          set rs = nothing
          Response.write( "Updated")
          %>
          <P>&nbsp;</P>

          </BODY>
          </HTML>
          Last edited by sweetjos; Mar 12 '10, 09:41 AM. Reason: sorry i send in wrong manner

            Comment

            • sweetjos
              New Member
              • Mar 2010
              • 10
              #4
              Thank you sir,
              I have another question....

              Recently I got this error.
              Error Type:
              Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
              [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
              /Jose/add.asp, line 21

              Browser Type:
              Opera/9.80 (Windows NT 5.1; U; en) Presto/2.5.22 Version/10.50

              Page:
              GET /Jose/add.asp
              My code is as follows.....

              <%@ Language=VBScri pt %>
              <% Response.Buffer = true %>
              <HTML>
              <HEAD>
              <META NAME="GENERATOR " Content="Micros oft Visual Studio 6.0">
              </HEAD>
              <BODY>
              <%
              Dim rs

              Set rs = Server.CreateOb ject ("ADODB.Records et")
              rs.CursorType = 2
              rs.LockType = 3
              rs.Open "register", "DSN=Registrati on"


              rs.AddNew
              rs("Name") = Request.Form ("name")
              rs("Age") = Request.Form ("age")
              rs.Update


              rs.Close
              set rs = nothing
              Response.write( "Updated")
              %>
              <P>&nbsp;</P>

              </BODY>
              </HTML>

                Comment

                Previous template Next
                Working...