I’m trying to run the following query:
DELETE Assessor.*, [Assessor].[Parnum]
FROM Assessor INNER JOIN NewMonth ON [Assessor].[Parnum]=[NewMonth].[Parnum]
WHERE (([assessor].[parnum]=[newmonth].[parnum]));
This worked previously, but now I’m getting an error message: “Could not delete tables.” The Jet error message is 3086. It says either the table is set to Read Only or I don’t have permissions. Both tables are on my hard drive. I created both of them. I’m logged in as Admin in NT. I installed the Access Workgroup Administrator some time ago, tinkering with it, but this was before the last time the query ran successfully. The table I’m trying to delete records from is the “master” and contains 36,000+ records consisting of property ownership information. I’m trying to delete the records in this table that match those in the New table. I want to replace the Old records with the New records. After the delete, I run an append.
Any ideas what’s going on and how I can correct this?