Home

Products

Downloads

Support

Contacts

1. Question:
I receive the following error message when trying to save changes I made to database:

Answer:

Issue
The following error: 80004005 � Operation must use an updateable query � occurs on a page when an event is updating or inserting into a recordset.

Solution
There are several things that may cause this ODBC error. Many of the possible reasons are listed below.

- The permissions that are set on the directory the database is in. IUSR privileges must be set to "read/write".

- The permissions on the database itself does not have full read/write privileges in effect.

- This error can also occur when the database is located outside of the inetpub/wwwroot directory. Though the information is still able to be viewed and searched, it cannot be updated unless it is in the wwwroot directory.

Additional information
For additional information on this error, please refer to following article in Microsoft's Knowledge Base:Q174640 - PRB: ASP: "The query is Not Updateable..." Error when Updating

Back to top

2.& 3. Question:
I receive the following error message when trying to save changes I made to database:

Answer:

This commonly occurs when you have a field name that is a reserved word.

Certain words (like table, field, date, note, select, password, level etc) are reserved by either ADO, OLEDB or by Access for use as commands or system objects.

You can get a list of reserved words in Access from the online help.

You should never use these words as names for tables or fields, nor should you have spaces in your tablenames. It is recommended that you rename your offending tables/fields and adjust your SQL statement accordingly.

Back to top

4. Question:

Answer:

Issue
When using an ODBC or OLE DB connection to a Microsoft SQL Server database in an ASP page, one of the following error messages may occur while attempting to view the page in a Web browser:

Reason
These errors are generated if SQL Server does not accept the logon account and/or password being submitted. One possible reason could be that a corresponding SQL Server account has not been setup for the Windows NT account that is used to access the database. An example of an account used to access the SQL Server database could be the IUSR_computername account used by Internet Information Services (IIS) for anonymous access to ASP pages.

Solution
Verify that a SQL Server authentication login or a Windows NT authentication login exists in SQL Server for the Windows user account that IIS uses to access the ASP page. If a login does not exist, use the SQL Server Enterprise Manager to create it. Also, when creating an ODBC Data Source Name (DSN) in the ODBC Administrator, make sure to choose the appropriate authentication method when you configure the DSN, and to test the DSN in the ODBC Administrator to verify that it is working correctly.
For information on how to configure SQL Server authentication or Windows NT authentication for SQL Server, please refer to the following Microsoft Knowledge Base articles:

Q247931 INF: Authentication Methods for Connections to SQL Server in Active Server Pages

Q183060 INF: Troubleshooting Guide for 80004005 and Other Error Messages

Additional information
For additional information about authentication methods and how they work, please refer to Understanding Anonymous Authentication and the IUSR Account (TechNote 15378) and WWW Authentication Methods (TechNote 15383), or the online IIS documentation.

Back to top

4. Question:

Answer:

Issue
The SQL error 80040E07 occurs when attempting to use the "Insert Record" or the "Update Record" server behavior to set the value of a column in Microsoft Access with an empty string ("").

Reason
MS Access is characterized by strong data typing; it imposes a rigorous set of rules on given column values. The empty string value in the command text (SQL) cannot be stored in MS Access' "Date/Time" data type specified by the associated column.

Solution
Try to avoid inserting and/or updating columns of "Date/Time" data types in Access with empty strings, ("") or with any other value that does not correspond to the range of values specified for the data type.

Back to top

6. Question:
I receive the following error message when trying to save changes I made to database:

Answer:

1. This commonly occurs when your database file opened exclusively by another application (usually MS Access). Close all applications that use this database and try again.

2. This error may occur if the account being used by Internet Information Server (IIS), (usually IUSR), does not have the correct Windows NT permissions for a file-based database or for the folder containing the file.

3. Check the permissions on the file and the folder. Make sure that you have the ability to create and/or destroy any temporary files. Temporary files are usually created in the same folder as the database, but the file may also be created in other folders such as /Winnt.

4. If you use a network path to the database (UNC or mapped drive), check the permissions on the share, the file, and the folder.

5. Check to make sure that the file and the data source name (DSN) are not marked as Exclusive.

6. Simplify. Use a System DSN that uses a local drive letter. Move the database to the local drive if necessary to test.

7. The "other user" might be Visual InterDev. Close any Visual InterDev projects that contain a data connection to the database.

8. This error may also occur when accessing a local Microsoft Access database linked to a table where the table is in an Access database on a network server. In this situation, please refer to the following article in the Microsoft Knowledge Base for a workaround:
   Q189408 PRB: ASP Fails to Access Network Files Under IIS 4.0

Back to top

7. Question:
I receive the following error message:

Answer:

This error can happen for a number of reasons. Usually it happens when path to the database is incorrect.

You need to check that the path to the database is correct. You need to make sure that database file was copied to the server.

The error is also quite common if the permissions on the server are incorrect. Check that IIS has sufficient permissions to access the registry and that the correct permissions, read and write, are set on the directory containing the database and the database itself, for the IUSR account.

Back to top

8. Question:
I receive the following error message:

Answer:

This error can happen for a number of reasons. Usually it happens due to server components conflict. You can try one of the following things to resolve this problem:

1. Restart IIS

2. Restart computer

3. Install or reinstall Microsoft Jet 4.0 Service Pack 6 (SP6)

4. Reinstall Microsoft Data Access Components (MDAC)

Back to top

Home | Products | Downloads | Support | Contacts

Contact us:

Unversal Data Solutions, Inc
Herndon, VA 20171, USA

  1-888-290-6617
  support@xlinesoft.com