Microsoft Access - Access 2007 two-table query will not allow edit.

Asked By D on 21-Feb-14 01:30 PM
I copied a 2013 database and removed all the data to reuse for a 2014 event.  A two-table query allows edit corrections/changes in the 2013 database but in the copied 2014 database I cannot make changes in the same two-table query.  Since I just copied the database and removed the data I cannot figure out what has changed that will not allow me to edit this two-table query...here is the SQL

SELECT [Reservations query].VIP, [Reservations query].TableNumber, [Reservations query].[Special Ticket Guests], [Reservations query].[Table Host], [Reservations query].[Special Ticket], [Reservations query].Comments, [Reservations query].ReservationsID, [Reservations query].[Sits With], [Reservations query].[Seat Number], [Reservations query].BidderNumber, [Reservations query].Guest, [Reservations query].[Reservations Payment Method], [Reservations query].[Reservations Number of Tickets], [Reservations query].[Reservations Ticket Price], [Reservations query].[Reservations Amount Total], [Reservations query].[Reservations Amount Paid], [Reservations query].[Reservations Balance Due], [Reservations query].[Name of Event], [Reservations query].Sponsorship, [Reservations query].Donation, [Reservations query].ID, [Reservations query].SALUTATION, [Reservations query].LastName, [Reservations query].FirstName, [Reservations query].MI, [Reservations query].Suffix, [Reservations query].SPOUSE, [Reservations query].[Company/Foundation], [Reservations query].[Mailing Address], [Reservations query].[Mailing City], [Reservations query].[Mailing State], [Reservations query].[Mailing Zip], [Reservations query].[Contact ID], [Reservations query].[Reservations Date Entered], [Reservations query].[Telephone--HOME], [Reservations query].[Cell Phone], [Reservations query].[Business Phone]
FROM [Reservations query]
WHERE ((([Reservations query].Donation) Is Null))
ORDER BY [Reservations query].LastName, [Reservations query].FirstName;

Thank you in advance.
D replied to D on 21-Feb-14 02:13 PM
Figured it out - some how the Primary Key in one of the tables had been "turned off".