Cannot Delete from a Table

[Renasant]

I have a long running database that failed this month on my delete query. I get error 2950 when I run it from within the macro. But I have the file and the network location trusted and all macros are trusted. When I step through the macro and when I run the delete query alone, I get "could not delete from specified location" (not the 2950 error).

Our network environment is Citrix desktops. Access runs from that desktop and is not a separately published application.

Any ideas on how to fix this or what changed to cause my query to fail this month?

 

[Renasant]

CORRECTION: I ran the table analyzer and performance analyzer last month. The delete query now points to a new query that access created for me to represent my old table. My append and update queries both point to this new query rather than the underlying table that access named table1. However, it seems like the delete query would need to point to the actual table rather than the query that represents the table.

Do I need to edit the delete query to point to the actual table that access created?

Thanks