![]() Make sure that you have enabled content in the database. If you are not sure, contact your system administrator or the database designer. Verify that you have the necessary permissions to delete records from the database. See if the Read-only attribute is selected. Right-click the database file and click Properties. Right-click Start and click Open Windows Explorer. Make sure that the file is not a read-only file: Top of Page Things to verify before you use a query to delete any data Makes it easier to delete values by updating the existing values to either a null value (that is, no data) or a zero-length string (a pair of double quotation marks with no space between them). To delete individual field values from a table. See the section on deleting data from related tables.ĭelete queries remove all the data in each field, including the key value that makes a record unique Note: If the records reside on the "one" side of a one-to-many relationship, you might need to change the relationship before you run the delete query.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |