Unable to add records to query in Access 2007
Microsoft Access has a setting in the Query Properties window called Recordset Type.  You need to set this to Dynaset (Inconsistent Updates) to allow your query to be updatable.