About an updatable query for an Access database

Source: Internet
Author: User
Tags modify query access database
access| Data | database when you write. NET programs, if you use Access to do a database, often forget something, and make the database inaccessible, and reported that the wrong is not very direct. For example, a query that is not updatable has been run. I also met in the asp.net. Depressed, a friend also helped me solve this problem. The method of its handling is very simple, should say should not be a big problem, but always forget, so the problem in this, to help people help already.

A: Your partition must be NTFS, you want to put the database files in the folder or database file security attributes to everyone plus modify or write permission

A: Not updatable it's yours. The account number that you want to modify the database cannot be modified. mdb, it may be the permissions of that account, or it may be. mdb itself is read-only, if it is XP, right click the database folder properties inside, will "allow other network users to modify my file" before the tick mark;
If it is Win2000, you can add write permission to everyone in the security, and only asp.net write permission can




Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.