468,510 Members | 1,712 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,510 developers. It's quick & easy.

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
Mar 3 '10 #1
3 3036
GazMathias
200 Expert 100+
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.
Mar 9 '10 #2
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=VBScript %>
<% Response.Buffer = true %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<%
Dim rs

Set rs = Server.CreateObject ("ADODB.Recordset")
rs.CursorType = 2
rs.LockType = 3
rs.Open "register", "DSN=Registration"


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>
Mar 12 '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=VBScript %>
<% Response.Buffer = true %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<%
Dim rs

Set rs = Server.CreateObject ("ADODB.Recordset")
rs.CursorType = 2
rs.LockType = 3
rs.Open "register", "DSN=Registration"


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>
Mar 12 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Gregory | last post: by
7 posts views Thread by p | last post: by
3 posts views Thread by Manuel | last post: by
5 posts views Thread by yashu0209 | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.