ASP. NET error records

ASP. NET Error Log final edit really · Jen

The following are some of the error records I have summarized in my previous ASP. NET Website Construction. I may not be able to use them in the future and hope to solve some problems of my netizens.

1. The minimum password length is 7, which must contain the following non-alphanumeric characters:
Registration occurred
Solution:
1>. Enter "~!" in the 7-digit password. @ # $ % ^ & * () _ + "One of them.
2>. Modify the file J: \ windows \ Microsoft. NET \ framework \ v2.0.50727 \ config-> machine. config
<Membership>
<Providers>
<Add name = "aspnetsqlmembershipprovider" type = "system. web. security. sqlmembershipprovider, system. web, version = 2.0.0.0, culture = neutral, publickeytoken = login "connectionstringname =" localsqlserver "Login =" false "enablepasswordreset =" true "Login =" true "applicationname ="/"requiresuniqueemail =" false "passwordformat =" hashed "Login = "5" minrequiredpasswordlength = "7" minrequirednonalphanumericcharacters = "1" passwordattemptwindow = "10" passwordstrengthregularexpression = ""/>
</Providers>
</Membership>
Minrequiredpasswordlength = "5" minrequirednonalphanumericcharacters = "0"
3>. If you only target a site, insert the code in the <membership> node into the <system. Web> node in Web. config.

2. Page. isvalid cannot be called before verification occurs. It should be queried in the event handler of the control with causesvalidation = true and enabled for sending back, or after page. Validate is called.
Page loading
Solution: If the verification control is used on the page, set the "causes validation" attribute of the control unrelated to the verification control to "false ".

3. The operator "=" is not compatible with the operand types "int32" and "object"
Page loading
Solution: I don't know the specific reason. I just don't have this problem after doing so.
Re-configure the data source or re-edit the entire page (after the system is restarted), and perform the compilation in stages rather than one-time compilation.

4. The delete statement conflicts with the reference constraint "fk_voteitem_votetitle1. This conflict occurs in the Database "fullvote", table "DBO. voteitem", column 'titleid '.
The statement has been terminated.
When you click Delete in the gridview1 control
Solution: When establishing a data table relationship, set "insert and update specifications", "delete rules" to "cascade", or "set null" (preferably "cascade ", does not occupy the tablespace as "set null ).

Insert and update specifications
Expand to display the "Delete rule" and "update Rule" information of the link.
Delete rule
This is the case when you try to delete a row that contains data related to the foreign key relationship.
No action an error message tells the user that the deletion is not allowed and the delete is rolled back.
Cascade deletes all rows containing data involved in the foreign key relationship.
Set null sets the value to null if all foreign key columns for the table can accept null values. Only applicable to SQL Server 2005.
Set the default value. If all the foreign key columns in the table have defined the default value, set the value to the default value defined by the column. Only applicable to SQL Server 2005.
Update rules
Specifies the situation when the user attempts to update a row that contains data related to the foreign key relationship.
No action an error message tells the user that the deletion is not allowed and the delete is rolled back.
Cascade deletes all rows containing data involved in the foreign key relationship.
Set null sets the value to null if all foreign key columns for the table can accept null values. Only applicable to SQL Server 2005.
Set the default value. If all the foreign key columns in the table have defined the default value, set the value to the default value defined by the column. Only applicable to SQL Server 2005.

5. The object reference is not set to the instance of the object.
The redirection button is clicked.
Solution: Set response. Redirect ("~ /Viewvote. aspx ") changed to response. Redirect ("~ /Viewvote. aspx? After titleid = "+ dropdownlist1.selectedvalue. tostring (), it is resolved. [The dropdownlist1 control is available on the current page]

6. The operator "=" and the operand type "int32 ?" Incompatible with "object"
Page loading
Solution: this problem no longer exists after other problems are solved.

7. No event can occur when you click the button.
Solution: The event name after the double-click button is inconsistent with the click event name in the button attribute.

8. The relationship "fk_student_examgroup" cannot be created ".
The alter table statement conflicts with the foreign key constraint "fk_student_examgroup. This conflict occurs in the Database "gpms", table "DBO. examgroup", column 'examgroupid '.
An error occurred while creating a foreign key relationship (fields are replaced in a table)
Solution: when creating a relationship between two tables, this problem occurs if a new field or field is added to a table and existing data exists in the table. add the corresponding data to another table or Delete the existing data.

9. When attaching a database to SQL2000, the system prompts "error 602; the row corresponding to index id1 of object id1 in database id7 cannot be found in sysindexes.
If you use sqlserver2005, this error will occur when you use SQL2000 to append the sql2005 database (solution: Use sqlserver2005 to append it, if you want to use the SQL2000 format, use the export SQL statement and other methods for conversion)
Solution for converting to csdnsql Expert proposal

Direct restore or attachment should not work, and it is certainly no problem to export data using scripts.

2005 to 2000 steps
1>. Generate the for2000 database script
Mangerstudio of 2005
-- Open "Object resource manager" (if not, press F8) to connect to your instance
-- Right-click the database to go to 2000
-- Task
-- Generate scripts
-- In the "select database" in the "script wizard", make sure that the selected database is to be transferred to 2000.
-- Select "write scripts for all objects in the selected Database"
-- In the next "select script options", find the "write script for server version" option and select "sqlserver2000"
-- Set other options as needed
-- Finally, save the script to A. SQL script file.

2>. Create the target database in 2000
In the query analyzer (or 2005 mangerstudio opens the script file), connect to sqlserver2000 and execute the script generated above to create a new database

3>. import data from 2005 to 2000
Mangerstudio of 2005
-- Open "Object resource manager" (if not, press F8) to connect to your instance
-- Right-click the database to go to 2000
-- Task
-- Export data
-- In the "Import and Export wizard" step of "Select data source", make sure that the database to be exported is selected.
-- In the "select target" step, connect to 2000 and select the library created in step 2.
-- In "select source table and source View", select all tables
-- Final Completion

10. User 'nt Authority \ Network service' Login Failed
IIS is configured as required, but cannot be viewed in localhost (the user name and password are not set for the corresponding database)
Solution:
In Windows XP, Asp. the Running Account of net is ASPnet, while in Windows Server 2003, the running account is changed to network service, and the user is directly added to the login account of SQL Server, in this way, many examples do not need to change the connection string!
Step 1: Add 'nt Authority \ Network Service' to the Administrator Group
My computer --> right-click --> Manage --> select "group" for local users and groups -->
Double-click administrators --> click "add" --> click "advanced" -->
Click "Search now" -->
In the following list, select the network service user --> click "OK" twice --> join.
Step 2 Add a netword service user to the Enterprise Manager
Open SQL Server Enterprise Manager -->
Select database instance -->
Open the "Security" node --> select "Logon" -->
Right-click the list on the right and select "New Logon" -->
On the "General" tab, click the button "..." next to "name" -->
Select the "Administrators" group --> click the "members" button below -->
Select "Network Service" --> click "add" -->
Click OK to return to the new logon dialog box -->
Ensure that the authentication type is "Windows Authentication" and "Allow access" -->
Double-click the user and select SysAdmin from the server role.
Click "OK" -->
Disable "Enterprise Manager"
Step 3: re-run the Asp.net program. Select windows for the database connection string.

11. It is incorrect to use the Section registered as allowdefinition = 'machinetoapplication' outside the application level. This error may occur if the virtual directory is not configured as an application in IIS.
Cause: allowdefinition = "machinetoapplication" in machine. config ".

Solution 1: Set allowdefinition to everywhere. It is recommended that you do not change the machine. config file. Otherwise, other errors may occur.

Solution 2: <Authentication mode = "***"> it is at the application level and cannot be in the web. config of the subdirectory level.
The setting can only be in the web. config at the root directory level. Therefore, delete the <authentication> section in the subdirectory.

12. When the delete, insert, or update operation is enabled, linqdatasource "linqdatasource1" does not support the select attribute.
By default, the linqdatasource control retrieves the values of all attributes from the data object. If you want to use a subset of available attributes, you can use the select attribute to specify the attributes to be returned. The Select Operation is applied after the where, order by, and group by operations. Therefore, if you create an alias in the select clause, the alias cannot be used in other clauses.
You can specify whether to enable data modification by using the enabledelete, enableinsert, and enableupdate attributes. The user interface used to modify data from the linqdatasource control is usually provided by the data binding control (such as the detailsview control. In addition to setting enabledelete, enableinsert, or enableupdate to true, the following conditions must be met to enable automatic data modification:
The select attribute cannot be assigned a value.
The groupby attribute cannot be assigned a value.
The class assigned to the contexttypename attribute must be derived from datacontext.
The attribute assigned to the tablename attribute must be derived from table <(of <(tentity>)> ).
You can use either of the following methods to restrict the attributes displayed in the data binding control. You can set the select attribute to the attribute subset, or you can add the datacontrolfield control to define fields for the data binding control. However, if the select attribute is set, automatic update, insertion, and deletion cannot be enabled. If you want to enable automatic data modification when using the available attribute subset, do not set the select attribute. Instead, retrieve all properties in the Data Object and manage the properties to be displayed by using the data binding control. When you use the detailsview control or the gridview control, you must set the autogeneraterows or autogeneratecolumns attribute to false. This will prevent the data binding control from automatically containing buttons for editing and deleting data. Any value that is not displayed in the data binding control is stored in the view State. When updating data, they are transmitted to the data source as they are.
If you must calculate the values for sorting, filtering, or grouping at run time, you can add the parameters to the whereparameters, groupbyparameters, ordergroupsbyparameters, or orderbyparameters set.
If you want to specify how to handle null string values or provide default values, you can add the parameters to the insertparameters, updateparameters, deleteparameters, or selectparameters set.
If you want to check or modify the value before performing a data operation, you can handle deleting, inserting, selecting, or updating events. You can also process these events to cancel data operations or check for verification errors that occur when setting properties in the data class based on user input.
To check the value after the data operation is completed, handle the deleted, inserted, selected, or updated events.
By creating an event handler for the selecting event, you can use the linqdatasource control to retrieve data from the stored procedure. In the event handler, call the method that represents the stored procedure in the data context class, and set the result to the result attribute of the linqdatasourceselecteventargs object. To enable automatic update, insert, and delete operations on data, the type returned from this method must match the type specified in the tablename attribute. For more information about how to create a data context method, see how to create a datacontext method (O/R designer) mapped to stored procedures and functions ).

13. The row that matches the given key in the original value stored in viewstate cannot be found. Make sure that the "keys" dictionary contains the unique key value corresponding to the row returned by the previous select operation.

An error occurred while updating data in listview.
Solution: Add attributes to the listview control: datakeynames = "primary key column name (one or more )".
Online query:
When using the aspxgridview control, click Edit to edit a row, update and cancel are displayed, and click Update after data editing. An error occurred: at the bottom of the row being edited, a sweaty background is highlighted in red, indicating that the specified method is not supported. The specified method is not supported.
The solution is to use the data source control to load data, specify that the performanceid of the aspxgridview control is equal to the ID of the data source control, and specify a keyfieldname. I learned this only after reading the official demo. I used to load data using the interface provided by the data access layer of our project. aspx. the CS file is bound to it. In this case, the data is updated because the aspxgridview control only displays data, but no data source exists after the webpage is loaded, therefore, you must use the data source control to save the data for update and update the data. I hope you can give us some advice on the unreasonable explanations.
There are many data source controls. Here we use objectdatasource, because our project already has a data access layer and we do not need to use other data source controls to access the database. Create a folder app_code under this web project, create a Class ABC under app_code, define the namespace as demo, and add a method loaddata in the namespace of the using data access layer, return the value of the datatable type. If the method parameter is specified, load the data in this method and return it. Then, add a method updatedata with at least one parameter, is the ID column and value to be modified to be passed to the stored procedure (these parameters must be added in the updateparameters attribute of objectdatasource. Their names are the same as those of these parameter names, they also exist in columns of the aspxgridview control. If you do not want to display columns, you can set visible = "false "), so we certainly need to modify some values, or we will not need to update, and no return value is required. In the method, we call the data access layer method to modify data.
Set the objectdatasource control's typename = "demo. ABC ", selectmethod =" loaddata ", updatemethod =" updatedata ", and also add the parameter name and value of selectparameters. The parameter name must be the same as the parameter name in the loaddata function. There are various options for the value, it can be a property of a control or a session variable, as needed, for example. Okay, this time there is no red word, and the data is successfully modified.

14. listview data update failed
After the above problem is solved, the data update is still unsuccessful.
Solution:
The problem is that I modified the content in the <edititemtemplate> label and did not notice the difference between <edititemtemplate> and <itemtemplate>. <% # %> one is eval () and the other is bind ().
The data to be modified is set to bind. The data that does not need to be modified is still eval.
See msdn: Data Binding expression syntax
All data binding expressions must be <% # And %> characters.
ASP. NET supports the hierarchical data binding model, which creates the binding between server control attributes and data sources. Almost any server control attribute can be bound to any public field or attribute. These public fields or attributes are located in the direct naming container that contains pages or server controls.
The data binding expression binds data to the control using the eval and bind methods, and submits the changes back to the database. The eval method is a static (read-only) method that uses the value of a data field as a parameter and returns it as a string. The bind method supports the read/write function. You can retrieve the value of the data-bound control and submit any changes to the database.
You can use the XPath and xpathselect methods and the xpathbinder class to bind the xmldatasource control to XML data. For more information, see xmldatasource Web Server Control.

15. Update Data in IE and then click the original data in the navigation bar (the database has been updated)
Solution:
The practice of not reading data from the buffer (referencing others)
It can also be implemented in JSP without reading data from the cache. See the following:
Method 1:
1> you can use the methods provided by Java in JSP or servlet.
<%
Response. setheader ("Pragma", "No-Cache ");
Response. setheader ("cache-control", "No-Cache ");
Response. setdateheader ("expires", 0 );
%>
2> Use HTML tags, as shown below:
<Head>
<METAHTTP-EQUIV = "Pragma" content = "no-Cache">
<METAHTTP-EQUIV = "cache-control" content = "no-Cache">
<METAHTTP-EQUIV = "expires" content = "0">
</Head>
Additional instructions:
The HTTP header "expires" and "cache-control" provide an application server with a mechanism to control the cache on the browser and proxy server. The HTTP header message expires tells the proxy server when its cache page will expire. The header information cache-control defined in the http1.1 specification can notify the browser not to cache any page. When you click the back button, the browser re-accesses the page that the server has obtained. The basic method for using cache-control is as follows:
1) No-Cache: force the cache to obtain a new page from the server
2) No-store: No pages are cached in any environment
The Pragma: No-cache in the http1.0 specification is equivalent to the cache-control: No-cache in the http1.1 specification and can also be contained in header information.
By using the Cache Control of the HTTP header information, the second example uses logoutsamplejsp2 to solve the problem of logoutsamplejsp1. Logoutsamplejsp2 differs from logoutsamplejsp1 in the following code segment, which is added to all protected pages:
//...
Response. setheader ("cache-control", "No-Cache"); // forces caches to obtain a new copy of the page from the origin server
Response. setheader ("cache-control", "No-store"); // directs caches not to store the page under any circumstance
Response. setdateheader ("expires", 0); // causes the proxy cache to see the page as "stale"
Response. setheader ("Pragma", "No-Cache"); // HTTP 1.0 backward compatibility
String username = (string) Session. getattribute ("user ");
If (null = username ){
Request. setattribute ("error", "session has ended. Please login .");
Requestdispatcher RD = request. getrequestdispatcher ("login. jsp ");
Rd. Forward (request, response );
}
//...
Method 2:
In IE, you can also set the new version of the stored page to check each access to the page by setting/tools/Internet Options/General/settings.

16. ASP. NET control textbox style overflow: visible is incompatible with IE6 and IE7
Currently, the biggest headache for web designers is the compatibility of web pages in various browsers. The longest difference in compatibility is the "page layout disorder", which is also the most frightening one ". A page is often displayed perfectly in IE6, but in IE7 (or Firefox), it is miserable ". What makes these pages so "unacceptable?
In fact, these are the consequences of IE6. IE6's lack of support for web standards and even misunderstanding lead to the "fragile" of these pages ". IE7 has fixed many bugs in "IE6's explanation and rendering of CSS. There are many such bugs. Today, I will only talk about one of them, but it is indeed the most important one. Many "very" chaotic pages are caused by it. To put it bluntly, it is like the behind-the-scenes hacker of "page layout chaos gang", which is one of the biggest and confusing pages. It is the "'overflow: visable' IE6 rendering bug" lurking behind the webpage ".
Cause-IE6's misunderstanding of "overflow: visible"
Visible: "This value indicates that content is not clipped, I. E ., it may be rendered outside the block box (Note: This sentence may be added later )".
Note: W3C only says that the container is not cut out. But it does not say that the extra content can "open" the container. In the following example, the explanation and rendering of IE7 are correct, while IE6 is incorrect (because it mistakenly thinks that only the content in the container is "opened" the container, so that the content in the container is not cut when it exceeds the limit), IE7 and Firefox are the same.
Solution
As you know, ie has two rendering modes: quirks mode and strict mode. Quirks mode is basically non-standard, including the box model. Its rendering method differs from W3C standard. The strick mode is basically a standard (neither an absolute standard nor an absolute non-standard ......). In IE6 and earlier versions, the rendering mode will be selected based on the doctype declaration written in the first line (or only the first line) of the XHTML document. If you find a doctype that you can recognize, such as XHTML transitional or XHTML strict, it uses strict mode for rendering. Quirks mode is used in all other cases.
Some developers explicitly declare that their XHTML document is an XML document and will be in the first line of the document (the problem is here, it must also be in the first line) add the preface of XML (Prolog ). For example:
<? XML version = "1.0" encoding = "gb2312"?>
Although the original intention is to make the document more "standard", because IE does not recognize this line of words, the results are still rendered in quirks mode.
IE7 solves this problem. It will skip the prolog to check the doctype. Therefore, IE6 and earlier versions may use quirks mode for rendering, while IE7 uses strict mode for rendering.
Now let IE7 render textbox in quirks mode, so that the overflow: visible attribute of textbox can be as effective as IE6, therefore, you only need to delete the doctype declaration in the first line of the XHTML document.
In this way, the problem is solved...
Note: although the display in IE7 and IE6 is the same, it is still different in FF, so this method can only solve the problem in IE7, FF is powerless.

Method 2: textboxid. Attributes. Add ("style", "overflow: visible ");

My solutions in gpms:
Delete the doctype declaration in the first line of the XHTML document
HTML, body {Height: 100% ;}
<Asp: textbox id = "textbox1" runat = "server" textmode = "multiline" cssclass = "textbox"/>
. Textbox {overflow: visible; width: 100%; Min-Height: 500px! Important; Background-color: # ffefd5; padding: 20px; padding-Right: 0! Important; _ padding-Right: 20px; Border: 0; margin: 0 ;}

17. W3C standard adaptive height height100 % does not work
In the previous webpage, the height: 100% can be used for the whole screen, but the following is added to the webpage header:
<! Doctype HTML public "-// W3C // dtd xhtml 1.0 transitional // en" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <HTML xmlns = "http://www.w3.org/1999/xhtml">
Later, we found that the height: 100% attribute was added to both HTML and body, which is the key to the highly adaptive problem.
------------------------------------------------ HTML, body {margin: 0px; Height: 100%;} ------------------------------------------------ whether an object height can be displayed in percentages depends on the parent object of the object, where the table is in the body, therefore, its parent level is body, and the browser does not have a height attribute for the body by default. Therefore, when we directly set # left to height: 100%, it will not produce any effect, but after we set 100% for the body, its child object table height: 100%; will function, this is a highly adaptive problem caused by browser parsing rules. In addition to the body application, the Code also applies the same style design to HTML objects. The advantage of this is that IE and Firefox can be highly adaptive. In addition, the HTML Tag in Firefox is not 100% in height, so the two tags are defined as height: 100%, to ensure that both browsers can be properly displayed.

18. an error occurred while selecting a data in listview only displaying the data: if the data is correctly displayed on the first page, if it is not displayed after the first page (the display content is the data corresponding to the first page)
Solution:
Empty data is first bound to the listviewdomainselectedindexchanging event
Bindnull ();
Bind and select data
Bindselected (newsid );

19. The freetextbox text box can be automatically wrapped when you input Chinese characters, but the text cannot be wrapped when you enter numbers or English letters.
Not solved, but the original official English version must be able to automatically wrap the line.

20. How to make the data wrap automatically? CSS helps you solve the problem [Absolutely!]

Where to add the style attribute of the table
"Word-break: Break-all; Word-wrap: Break-word"
In this way, we can keep the page unchanged... even the long string of text is no problem...
(Solved one of my difficulties: If the input content in textbox is not converted by carriage return, it will not automatically wrap if it is displayed in highly adaptive textbox) (but cannot be perfectly explained in Firefox) [other issues that cannot be automatically wrapped can also be solved using this method?]

21. The page is automatically extended after the button is clicked in Firefox
Solution: remove the <div> medium attribute "height: 100%" in the main section of the page ".

22. The sequence does not contain any element.
When a field is queried in a data table, the value is equal to a parameter value, but the field has not been assigned a value.
Solution: first determine whether the specified field contains the passed parameter and then determine whether it is null.
VaR stuidinclude = from o in dB. Result
Select O. stuid;
If (stuidinclude. Contains (stuid ))
{
VaR term = from P in db. result where P. stuid = stuid & P. termid = termid select P;
If (term. Count ()> 0)
Return term. First (). termresult;
Else
Return NULL;
}
Else
Return NULL;
You can also directly determine whether the field is null (regardless of whether the field is assigned a value). [This method is better]
VaR term = from P in db. result where P. stuid = stuid & P. termid = termid select P;
If (term. Count ()> 0)
Return term. First (). termresult;
Else
Return NULL;
23. The index is out of range. It must be a non-negative value and smaller than the set size.
Parameter Name: Index
Row 85: teaid [I] = listview1.datakeys [I]. value. tostring ();

The primary key is obtained cyclically using listviewincluitemdatabound (Object sender, listviewitemeventargs E ).
Solution: Use the listviewdomaindatabound (Object sender, eventargs e) event instead.

24. You cannot add an object whose key is already in use.
Cannot add an object whose key is in use (a main table, B foreign key table )?
Solution:
A. assign a value to the foreign key ID. Note:. id = 11, then B. aid =. ID, but: int I = 11,. id = I, B. aid = I;
Automatically increasing columns in Table B
When modifying a. ID:
Find the object etnewa of the new A. ID first, and then update (etnewa) the corresponding etnewa. B. Add (etb) of B)

Article Source: http://www.diybl.com/course/4_webprogram/asp.net/asp_netshl/2008821/136763.html

25. The control in listview is invalid.
When browsing in a browser, the page control and other links in listview are invalid.
Cause: the verification control is used on this page, while causesvalidation = "true" is used only for some controls, but the causesvalidation attribute is not available in listview, therefore, the control is invalid.

26. The request. form value is detected in the client.

Note: The request verification process detects potentially dangerous client input values. The request processing has been suspended. This value may indicate attempts to compromise application security, such as cross-site scripting attacks. You can disable request verification by setting validaterequest = false in the page instruction or configuration section. However, in this case, it is strongly recommended that the application explicitly check all input.
Solution:
At the top, <% @ page Language = "C #"... Add validaterequest = false to %>.

27. truncates character data. The \ r \ n statement has been terminated.
Cause: exceeds the database field length.
Solution: Adjust the database Field Length

28. The database does not have a valid owner, so you cannot install the database relational diagram support object. To continue, first set the database owner to a valid login name using the "file" page or the alter authorization statement in the "database properties" dialog box, and then add a database relational diagram support object.
Cause 1: The database backed up in SQL Server 2000 is restored to SQL Server 2005, and a new database relationship diagram is planned. However, in Microsoft SQL Server Management studio, a folder for the database relationship diagram is located, the following error occurs: "This database has no valid owner, so you cannot install the database relational diagram support object. To continue, first try the "file" page in the "database properties" dialog box or the alter authorization statement to set the database owner as a valid login name, the prompt "add database relational graph support objects" is followed by the designated owner. Unfortunately, it is still incorrect. Check the prompt and execute the following statement:
Use [Master]
Go
Exec DBO. sp_dbcmptlevel @ dbname = n' database name', @ new_cmptlevel = 90
Go
Because the 2000 backup database is restored to 2005, the compatibility level is 80, and it will be OK if it is changed to 90.
Cause 2:
When you restore the database backed up from another machine to your machine and click the database relationship diagram of this database in SSMs, the following prompt is displayed:
The database does not have a valid owner, so you cannot install the database relational diagram support object. To continue, first set the database owner to a valid login name using the "file" page or the alter authorization statement in the "database properties" dialog box, and then add a database relational diagram support object.
The database is determined to have a database relationship diagram. The following two methods are provided: the first method is difficult to use after several attempts, and the second method is successful. Specifically, run the following command in SSMs:
Alter authorization on Database: mydbname to sa
Modify mydbname to the actual database name, and set the owner to sa.

29. The update statement syntax is incorrect.
The update statement trace is checked over and over again, and no exception is found. What's more strange is that the update statement is directly run in access. There is no error at all.
Solution:
Enclose the field name.