Delete Query Tutorial
The Delete query in MS Access SQL command used to remove one or more rows of data
from a relational database table. The number of rows deleted is dependent upon the existence and criteria within the where
clause of the delete query.
Microsoft Access is a fully capable database and it's primary limitations is the number of concurrent users it will support. Generally, we recommend a limit of 10 to 15 users.
Did you know you don't need to move to SQL/Server to run and manage your Access database on the net. There are many alternative solutions. Among them are Amazon's AWS cloud services and various hosting services in nearly every state.
The basic syntax of the Access Delete query is:
Delete Table Name.* From Table Name Where some criteria;
Note that using an Access delete query without the where clause will delete all rows from the specified table.
The asterisk in Table Name.* is a wildcard character and refers to all fields within the table. You may only
delete entire records rather than values in particular fields therefore the asterisk is mandatory.
If Table Name is a table which is defined as the master of a master-detail relationship and the
property of the relationship is set to true then corresponding records in the detail table will also be deleted.
The delete method is often preferable to the drop table method,
which completely removes the table from the database, because all of the characteristics of the
intact - such as the indexes, relationships and primary keys.
Now with real column and table names:
Delete * From M_Employees Where Emp_Name = "Joe";
The above query will delete all employees with an employee name of Joe.
More Access Delete Query Examples:
Docmd RunSQL Access Database Example
Visual Basic Select Case in Access
Concatenate Records Text Field