Regarding Access, the query function is implemented based on automatic numbering

Because ID auto-numbering is. Integer type. Of course you can't put two quotation marks.

You're going to change it to: f_id = "namekey"(Here's what to output).

If the content is characters. Use "" if not. Not added.

f_id=trim("namekey"))"id"))

You can't put quotation marks in it at this time.

ASP beginners encounter confusion, please help you, be sure to come.

1. Back up the access database (this is required).

Design view - select the ID column - there is a "New Value" column below, select "Increment" (ID is set to long integer).

Select the table, right-click the design, and select Auto Number in the ID field.

When designing a database, should the id column attribute be incremented or random?

The way to prevent this is to strengthen the processing of data, for example, the interval between adding new data, requiring the entry of a randomly generated verification code, verifying the legitimacy of the submitted data, verifying the data page, and verifying the identity of the person who added the data.

1. Back up the access database (this is required).

2. Open the database, right-click Table A where you want to modify the ID value, open the "Design View", change the number type of the ID field from "Auto Number" to "Number", and close the save.

3. Then open Table A, modify the ID value, and you can also modify other existing data. Close the table after the modification is complete. (At this point, the id field cannot be changed back to the "autonumber" data type).

4. Right-click Table A, select "Copy", then right-click on the blank space, select "Paste", write the table name as you like, such as "AA", select "Paste Structure Only", and then click OK to generate a new table AA.

5. Select Table AA to open Design View. Change the data type of the id field to "Auto Numbering" and turn off saving. (At this point, there is no data in Table aa, so it can be modified successfully).

6. Right-click Table A, select "Copy", then right-click the blank space, select "Paste", write the new table "aa" just generated by the table name, select "Append data to existing table" below, and finally click OK.

7. Then rename the original table A to A111, and rename the table AA to A. This makes it possible to replace the old table with the new one

1. Back up the access database (this is required).