Otherwise, the update query sets to NULL every record in each of the fields in your query. The Relationships tab displays the tables in your database and the relationships. In this case, login as the administrator or with a user name and password that gives you the appropriate rights.
Change this at the Windows level. Select the table which has the data you want to delete if the table is related, select the table on the "one" side of the relationshipclick Add, and then click Close.
In the case of a Delete Query, Access will find a group of records matching a given criteria and delete them from the database table. This is where an Access Delete Query is going to prove very useful. Student membership lasts for 2 years.
It simply fails to run.