Error Number:-2147467259 what is the error

Usually cause error number:-2147467259 Most of the reason is the database connection problem, may be the service does not open the issue, there may be folder permissions are not open issue, the specific error number:-2147467259 reasons are as follows:

1, the most common reason is that the anonymous user account (Iusr_machine) does not have write access to the database file.

To resolve this problem, adjust the properties of the database file in the organizer so that anonymous users have the correct permissions. When you use an Access database, you will not only write permissions to the file, but also write permissions to the directory, because Jet needs to create a. ldb file in that directory.

2, the second reason is that the database does not use the correct mode to open. You should open it using the following method.

SQL = "UPDATE products Set UnitPrice = 2;"

Set Conn = Server.CreateObject ("ADODB. Connection ")

Conn.mode = 3 ' 3 = adModeReadWrite

Conn.Open "MyDSN"

Conn.execute (SQL)

Conn.close

Note that the default mode is set 0 (adModeUnknown), which is allowed to be updated.

3. It is also possible to select the Read-only option for this DSN in the ODBC Administrator.

4, you are updating the fields in two tables at the same time, you will also receive this error message, the solution is to update the two tables in separate fields.

5. This error occurs when you use a query that is loaded into a high version (ACCESS 2000) from a lower version (such as access2.0,access7.0). At this point we can consider and solve these several methods.

Through the above analysis of several reasons, we can analyze and solve one by one, or give permission to write, or solve the version of the problem, of course, perhaps a second system on all OK, this small series is set to write permission to solve the problem, can be compared with the above 5 reasons to solve 2147467259 error problems.