ODBC Microsoft Access Driver cannot be updated?? The database or object is read only??

Updated on technology 2024-03-21
1 answers
  1. Anonymous users2024-02-07

    It is most likely that the disk where your access is located is in NTFS format.

    This format requires the account to have permission to modify it so that access can be updated.

    Method: Change the format to fat32 (hehe, it's not very realistic, just kidding...)

    Method 2: If the partition is in NTFS format when configuring a site, you will encounter a read-only error in the 80004005 database or object, for example:

    Microsoft OLE DB Provider for ODBC drivers error'80004005'

    Microsoft][ODBC Microsoft Access Driver] cannot be updated. The database or object is read-only??

    The problem with this is the access to the site directory, because when using the access database, one is generated in the same directory. ldb file, if the directory does not have write permission or the access database itself does not have write permission, this error will be reported. Since most of the access through the browser is anonymous on the Internet, we only need to add the "iusr computer name" user to the directory permission of the database and assign it the "write" permission.

    I've found some articles that say it's dangerous to let everyone be added and give "write" permissions. In principle, this directory can be written to the user, which is the Internet anonymous access user added when configured in IIS, and the default is generally "iusr computer name", but if it is a virtual host, you have to see it yourself.

    Here's how it works:

    Right-click on the directory where the database is located (or its parent directory, but be aware of the ability to inherit permissions) - Select "Share & Security" - Select the "Security" tab - Click the "Add" button - Click "Advanced." Button- Click on the "Find Now (N)" button- Find the username prefixed with "iusr" (in the format of iusr computer name) - Select the user, click OK - This user will be added - In the permission box of "Internet guest account", in addition to the default one, check "Write permissions" - Apply or "OK".

    Tips: If you can't find the "Sharing and Security" option under the WinXP system, you need to set it up first: "Tools" - Folder Options "- View "- Use Simple Share by Default (Recommended)", remove this option, and then right-click on the folder, and the security option will appear.

    The next paragraph was found on the Internet, and I don't want to type!!

Related questions