I get the error message "Could not delete from the specified tables"
When you run a delete query (delete query: A query (SQL statement) that removes rows matching the criteria that you specify from one or more tables.), Microsoft Office Access 2007 may display the error message Could not delete from the specified tables. This article lists cases in which you can use a delete query, explains why the error message appears, and provides steps for correcting the error.

---

Avoiding divide by zero errors in Access
If you try to divide a number by zero in Access, you receive a #DIV/0 error if you are in a form or report, or a #ERROR error if you are in a query. To avoid a divide by zero error, you can use the IIF function to set the results field to a zero-length string ("") if the divisor in a calculation is zero. You can then search the field for any values that contain a zero-length string and flag the results. The following steps demonstrate this technique by creating a table and a bound form, inserting three text boxes, and entering an expression.

---

Syntax error - missing operator
I am trying to compile a code for emailing individuals from my database but come up with a syntax error from ther where statement.

---

Can't Access Table in MS Query
I received the following error message when trying to create a new database query in Excel 2003: Can't access table C:Documents and Settings…My DocumentsTester.mdb.qryTest. I found a few knowledge base articles, but nothing relevant to my situation. I almost never use the wizard to create external data queries, but I thought I'd give it a shot. Using the wizard, I get this error: Undefined function 'Nz' in expression.

---

DlookUp Error
What is wrong with this expression? (Access 2002) VoyageExists = Nz(DLookup("[ID]", "Delivery", "[Delivery.VesselName] ='" _ & Forms![Inputs]!cbVesselName _ & "' And [Delivery.ArrivalDate] ='" & _ Forms![Inputs]!txtArrivalDate & _ "'And [Delivery.ID] <>'" & _ Forms![Inputs]!txtTaslimID & "'"), "-1") Error 3646 Data type mismatch in criteria expression

---

Database variable not defined error
I'm running an Access 2003/XP/2000/97 database with some VBA code in it. Within the VBA code, a database object is declared as follows: (Dim db As Database) When this code is encountered, Access highlights the line and I receive the following error message: (Compile error: User-defined type not defined) I've seen this code work in other Access databases. How come it does not work in mine?

---

Error Trapping
You can use the On Error GoTo statement to trap errors and direct procedure flow to the location of error-handling statements within a procedure.

---

Elements of Run-Time Error Handling
When you're programming an application, you need to consider what happens when an error occurs. An error can occur in your application for one of two of reasons. First, some condition at the time the application is running makes otherwise valid code fail. For example, if your code attempts to open a table that the user has deleted, an error occurs. Second, your code may contain improper logic that prevents it from doing what you intended. For example, an error occurs if your code attempts to divide a value by zero.

---

No Data and Report Error
Report Source Query or Table can end up with no output records. In that case some of the controls with formula on the Report will show #Error on them.

---

Add, remove, or change error bars in PivotChart view
Error bars graphically express potential error amounts relative to each data marker in a data series. You can add one set of error bars per series.

---

Operation must use an updateable query
I receive the following error message when trying to save changes i made to database: microsoft ole db provider for odbc drivers error '80004005' [microsoft][odbc microsoft access driver] operation must use an updateable query. /tablename_edit.asp, line xxx

---

How to determine why Access is unable to create an MDE database
I tried to compile my MDB database into an MDE file, but I received the error: "Microsoft Access was unable to create an MDE database." There weren't any other error messages. How can I find out what the problem is?

---

Resolving report errors
How do I avoid #Error in my reports? I want to use Sum([InvoiceAmt]). InvoiceAmt is a number field. However, in some cases there is no data and the Sum function does not work. The report prints a #Error and the total is "#Error". How can I get around this?

---

How to solve the Could Not Lock File Error
This error occurs when the .ldb file is not automatically deleted when the user closes MS Access. In theory, the .ldb file should automatically get created when user connects to the database and automatically get deleted when user stops using the database. The way to fix this problem is to delete the .ldb file. The .ldb file will be in the same folder as the database itself. If the File in Use error is received when trying to delete the .ldb file.

---

Access 2007 Error - when I try to import a text file
I am having some issues with Access 2007. When I try to import a text file into a table using a predefined spec, the routine will run for a while and then error out with the message "the search key was not found in an record". Any ideas on what this is and how I can fix it??

---

Avoid #Error in form/report with no records
Calculated expressions show #Error when a form or report has no records. This sort-of makes sense: if the controls don't exist, you cannot sum them. How to suppress the #Error that Microsoft Access displays in forms and reports that have no records.

---

Customize Not In List error message
My users get a generic error when they type something in a combo box control that is not in the list. I still want to force them to select a choice from the list, but how do I customize this error message to make it more friendly?

---

Handle Run-Time Errors in VBA
When you are programming an application, you need to consider what happens when an error occurs. An error can occur in your application for one of two of reasons. First, some condition at the time the application is running makes otherwise valid code fail. For example, if your code attempts to open a table that the user has deleted, an error occurs. Second, your code may contain improper logic that prevents it from doing what you intended. For example, an error occurs if your code attempts to divide a value by zero. Learn how to trap run-time errors.

---

Error accessing file - or - This action will reset the current code in break mode
When you try to view the code for a Visual Basic for Applications module, compile a database, create an MDE file, or execute code in an Access 2000 database, you may see one of the following messages: "Error accessing file. Network connection may have been lost." "This action will reset the current code in break mode."

---

Functions available in PivotTable or PivotChart view of a form
A control in a data access page or a form that is open in PivotTable view or PivotChart view can contain an expression that uses a Microsoft Visual Basic for Applications (VBA) function. However, the expression will generate an error unless it appears on the following list.

---

Use the Expression Builder
You can use the Expression Builder to help build expressions. The Expression Builder provides easy access to the names of the fields and controls in your database, and to many of the built-in functions that are available to you when you write expressions. In this article: Understanding the Expression Builder, Start the Expression Builder from a table, Start the Expression Builder from a form or report, Start the Expression Builder from a query.

---

Problem opening access form
I am getting an error message that says "There isn't enough memory to perform this operation. Close unneeded programs and try the operation again". I have shut everything down and still the error occurs.

---

Run-time error on form
I have set up a database for monitoring users of our financial system. with the user ID being numeric, and everything has worked fine. Recently the administrators of the database have asked me to alter the database to accept alphanumeric ID's. After changing the data type to text, certain of my forms that use a filter are producing the following error message. "Run-time error '2501' The ApplyFilter action was cancelled. You used a method of the DoCmd object to carry out an action in Visual Basic, but then clicked Cancel in a dialog box." I know that the error message is due to the change in data types, because when I delete the alphanumeric data and change the type back, the forms work again.

---

Prevent a query from timing out
In Access 2003, I keep getting an ODBC timeout error when I run my query. How can I prevent the query from timing out?

---

Error Handling in VBA
Every function or sub should contain error handling. Without it, a user may be left viewing the faulty code in a full version of Access, while a run-time version just crashes.

---

Access Error, runtime error 2424
Hello there All, has anyone seem this runtime error 2424?

---

When I go to open .mdb it gives and error then installs
I have Office XP installed and all apps within it work just fine when I open them except Access. When I try to open Access with a shortcut on my desktop, I get and error that says "Windows cannot find the file...". Behind that message, another opens that says "Preparing to Install... please wait while Windows configures Office XP Professional" If I go to the folder called C:Program FilesMicrosoft OfficeOffice10 and click on the MSACCESS.EXE file itself, there is no error, but it does the install part. Word and Excel start perfectly without this issue. I tried using the cd to repair the installation, but this had no effect.

---

Replace system error message with a custom message
In Access 2003/XP/2000/97, I have a form that is linked to an Oracle table. When I enter duplicate data, I receive an error message "ODBC - failed... Unique Constraint violated...".

---

Troubleshoot filters
I am having problems applying a filter: Saved filters are not getting applied to a view or report. I don't see lists of field values in the Filter By Form window. I get an error message saying my expression is not valid. Some form fields are not available as criteria fields in the Filter By Form window. I cannot filter based on a combo box by using the Filter By Selection technique. I want to use a query as a filter, but the query is not listed when I click Load from Query. The filter commands appear dimmed and are unavailable in Datasheet view and Form view. I want help with troubleshooting filters in an Access project. I applied a filter, but... Some records are missing (I see too few records). The filtered view shows too many records. The filter returnset looks different from what I think it should be. I filtered the subform or subdatasheet, but it did not filter the main form or datasheet. The returnset is not sorted properly. I want to test my filter before I distribute the database.

---

Nest a query inside another query or in an expression by using a subquery
Sometimes you may want to use the results of a query as a field in another query, or as a criterion for a query field. For example, suppose that you want to see the interval between orders for each of your products. To create a query that shows this interval, you need to compare each order date to other order dates for that product. Comparing these order dates also requires a query. You can nest this query inside of your main query by using a subquery (subquery: An SQL SELECT statement that is inside another select or action query.). You can write a subquery in an expression (expression: Any combination of mathematical or logical operators, constants, functions, and names of fields, controls, and properties that evaluates to a single value. Expressions can perform calculations, manipulate characters, or test data.) or in a Structured Query Language (SQL) statement in SQL view (SQL view: A window that displays the SQL statement for the current query or that is used to create an SQL-specific query (union, pass-through, or data definition). When you create a query in Design view, Access constructs the SQL equivalent in SQL view.).

---

Run a query
A query is a set of instructions that you can use for working with data. You run a query to perform these instructions. In addition to returning results which can be sorted, grouped, or filtered a query can also create, copy, delete, or change data. This article explains how to run queries and provides only brief overviews of the various types of queries. The article also discusses error messages you might encounter when you run different types of queries, and provides steps you can take to work around or correct those errors.

---

You receive an error when you try to create a new report in Access 2000 without a default printer
When you try to create a new report, you may receive one of the following error messages. You may receive the following error message if you use the wizard to create a new report: You must install a printer before you can create a report. To install a printer, point to Settings on the Windows Start menu, click Printers, and then double-click Add Printer. Follow the instructions in the Add Printer wizard. Click OK in this dialog after you have done this, and the report wizard will continue.

---

Access XP Crashes at Query Run
I have Microsoft Office XP SP3 installed on an Windows 2000 Pro PC. It works great except for when I'm attempting to run one query in Access XP. This is a query that is based on imported data from Excel 2000. The query was also built from Access 2000 (Office XP is a new upgrade for this PC). The query works fine from PCs running Access 2000, but causes Access XP to crash with no warning. (the application just closes completely and gives no error message) Can anyone provide information on this problem? Is there an application log I can check? Again, other queries work fine but this query crashes the whole app. Thanks in advance for your help!

---

Access, Acwzmain.mde
I am tryting to install either office pro Access or office 200 Access. I get the same error with both. f:pfilesmsoffice1031Acwzmain.mde (make sure that the file exist and that you can access it). I went to Microsft and looked it up and it says it could be my virus scan. I went into Norton and look it out and I still get the error. Please help!!! I am using Windows XP pro.

---

ActiveX component can't create object
When you use Microsoft Access, you receive the following error message: ActiveX component can't create object This article describes some common causes for this error message and offers methods that you can use to resolve the issue.

---

Prevent a query from timing out in Access 2000
In Access 2000/97, I keep getting an ODBC timeout error when I run my query. How can I prevent the query from timing out?

---

Relationship and expression in Microsoft Access
I want to setup a database by using Microsoft Access. But I do not really understand the Relationship and Expression. I want to know how the tables relate each other, and use the expression to query multi-table.

---

Programming Tips
Error Messages with Forms and Linked Tables; Error Messages on Forms (without linked tables); Linking to Outlook/Exchange; Exporting Reports; Speeding up Reports and Queries; Putting Information into Word or Excel; Copying Information to the Clipboard; You may also wish to read our companion article on how to distribute databases with the Access Runtime edition

---

Customize Not In List error message
How do I programmatically add an item to a combo box that wasn't originally in the list? When my users type in a value that is not in my combo box list, they get an error. Instead, I want a message to ask the user if they want their desired item added to the list. How do I do this?

---

Expressions, Conditions, and Operators
The definition of an expression is simple: An expression returns a value. Expression types are very broad, covering different data types such as String, Numeric, and Boolean. In fact, pretty much anything following a clause (SELECT or FROM, for example) is an expression. In the following example amount is an expression that returns the value contained in the amount column.

---