-
Anonymous users2024-02-07Causes: There are several main reasons for the error:
This error occurs when your program tries to update the database or something similar. This is because.
ADO is unable to write to the database for several reasons.
1。The most common reason is that the anonymous user account (iusr machine) does not have write access to the database file.
To solve this problem, adjust the properties of the database file in the manager so that the anonymous user has the correct permissions.
When using the access database, you must not only give permission to write to the file, but also to the directory, because.
jet needs to be set up in that directory. LDB file.
2。The second reason is that the database is not opened with the correct schema. It should be opened using the method below.
sql = "update products set unitprice = 2;"
set conn = "")
3 '3 = admodereadwrite
mydsn"
Note that the default mode is set to 0 (admodeunknown), which allows updates.
3。It is also possible that the read-only option of the DSN is selected in the ODBC Manager.
4。This error message will also appear if you are updating a field in two tables at the same time, and the solution is to update them separately.
Each field in both tables.
5。When you use a load from an earlier version (e.g., load to a higher version (access 2000)).
This error occurs when executing this query.
If it is a WinXP system.
Use simple sharing by default in the folder options (recommended),Remove this option,Then right-click on the folder,The security tab will appear,The original default is not,Then you can set the user's write permission in the security tab。
Right-click on the database "Security" everyone> and check the required one.
-
Anonymous users2024-02-06This should be the problem with using asp out your database file*The folder where the MDB is located does not have read and write permissions granted to the ASP Internet guest account.
-
Anonymous users2024-02-05There are three ways to import external data (Excel) with Access:
Right-click the table and select Link Table Manager.
Select the linked table that needs to be updated, and then click OK.
-
Anonymous users2024-02-04The other party must have done something to the software.
After all, I left my job.
The Software is the intellectual property of the other party.
You can only contact him personally.
Let's see if we can get his help.
-
Anonymous users2024-02-03Excel data is not updated in real-time in Access.
1. Create an access database and create a new table in the database—that is, an additional table. By setting the property values of the attached table, make it linked to the database you want to access. >>>More
Enterprise Manager Create a database in SQL Select All Tasks Import Data Select Microsoft Access from Data Source When importing the Access database to the MSSQL database, there are several issues that should be paid attention to When using MSSQL Server, there are many differences with Access, even if you use SQL Server to import the Access database, there are many places to pay attention to. 1. After importing the auto-numbering field often used in Access, it is not an auto-incrementing int, and it needs to be manually set to change the "no" of the imported auto-numbering field to "yes", and the "seed" and "increment" are both "1" in order to become an auto-number; 2. In MSSQL Server, there are many reserved words, which are not available in Access, and when you import data into MSSQL, the problem will come out. MSSQL will automatically add "[field name]" to these fields (including the table names in the database) when importing, so you must modify your script to add parentheses to the corresponding field names (or table names), or change the field names to non-MSSQL reserved words. >>>More
Well, with ADO, you can directly select and output to excel, for example, insert into [excel; database='c:\''sheet1$''(Field 1, Field 2,...)from .. >>>More
Contact 26819801 and I'll take a look at that for you.