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

Subscribe Post Reply

3239

GazMathias

228

Expert 128KB

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

sweetjos

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> </P>

</BODY>
</HTML>

Mar 12 '10 #3

sweetjos

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> </P>

</BODY>
</HTML>

Mar 12 '10 #4

by: AIM | last post by:

Error in msvc in building inheritance.obj to build hello.pyd Hello, I am trying to build the boost 1.31.0 sample extension hello.cpp. I can not compile the file inheritance.cpp because the two...

Python

Reference-counted error objects

by: Gregory | last post by:

Hi, One of the disadvantages of using error handling with error codes instead of exception handling is that error codes retuned from a function can be forgotten to check thus leading to...

C / C++

Error Handler best practices

by: deko | last post by:

I use this convention frequently: Exit_Here: Exit Sub HandleErr: Select Case Err.Number Case 3163 Resume Next Case 3376 Resume Next

Microsoft Access / VBA

Error crystal websetup 9 install

by: p | last post by:

WE had a Crystal 8 WebApp using vs 2002 which we upgraded to VS2003. I also have Crystal 9 pro on my development machine. The web app runs fine on my dev machine but am having problems deploying....

ASP.NET

error: syntax error before '*' token

by: Manuel | last post by:

I'm trying to compile glut 3.7.6 (dowbloaded from official site)using devc++. So I've imported the glut32.dsp into devc++, included manually some headers, and start to compile. It return a very...

C / C++

Fw: [wxPython-users] 1>make_buildinfo.obj : error LNK2019: unresolvedexternal symbol __imp__RegQueryValueExA@24 referenced infunction _make_buildinfo2

by: f rom | last post by:

----- Forwarded Message ---- From: Josiah Carlson <jcarlson@uci.edu> To: f rom <etaoinbe@yahoo.com>; wxpython-users@lists.wxwidgets.org Sent: Monday, December 4, 2006 10:03:28 PM Subject: Re: ...

Python

Custom Error Messages in Access

by: hyperpau | last post by:

Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I...

Visual Basic 4 / 5 / 6

Custom Error Messages

by: hyperpau | last post by:

Microsoft Access / VBA

Error while compiling

by: yashu0209 | last post by:

I have an error occurring when i try to compile the program and the error is: D:\Program Files\visual studio 6.0\MSDev98\MyProjects\GLEnabledView\GLNew.cpp(164) : error C2653: 'CGLEnabledView' :...

C / C++

error LNK2001 and error LNK2005

by: randa zaghdan | last post by:

Hi I have a problem with my program in vc 2008 When I compile it, the following errors are listed. I try to resolve it but no hope Does any one can help me ? thanks . Linking......

C / C++

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Similar topics