Mike & Doris Manning
mikedorism at verizon.net
Wed Jul 13 10:12:05 CDT 2005
It is highly possible that with the joined tables, you've created a non-updatable query. Doris Manning Database Administrator Hargrove Inc. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester Sent: Wednesday, July 13, 2005 11:07 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Cannot delete from specified tables Thanks for the suggestion but I still get a message cannot delete from specified tables. I don't understand why since this a stand alone database on my local computer (C drive). -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mike & Doris Manning Sent: Wednesday, July 13, 2005 9:55 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Cannot delete from specified tables Try DELETE [tbl Allocations].* FROM [tbl Allocations] INNER JOIN [tbl Patterns to delete from Allocation table] ON ([tbl Allocations].TargetPID = [tbl Patterns to delete from Allocation table].TargetPID) AND ([tbl Allocations].SourceNAME = [tbl Patterns to delete from Allocation table].SourceNAME) WHERE ((([tbl Allocations].SourceNAME)=[tbl Patterns to delete from Allocation table]![SourceNAME]) AND (([tbl Allocations].TargetPID)=[tbl Patterns to delete from Allocation table]![TargetPID])); Doris Manning Database Administrator Hargrove Inc. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester Sent: Wednesday, July 13, 2005 9:32 AM To: accessd at databaseadvisors.com Subject: [AccessD] Cannot delete from specified tables When I try to run the sql below I get the message cannot delete from specified tables. The tables are native to a stand alone access DB. I have tried many combinations but still no luck. DELETE [tbl Allocations].*, [tbl Allocations].SourceNAME, [tbl Allocations].TargetPID FROM [tbl Allocations] INNER JOIN [tbl Patterns to delete from Allocation table] ON ([tbl Allocations].TargetPID = [tbl Patterns to delete from Allocation table].TargetPID) AND ([tbl Allocations].SourceNAME = [tbl Patterns to delete from Allocation table].SourceNAME) WHERE ((([tbl Allocations].SourceNAME)=[tbl Patterns to delete from Allocation table]![SourceNAME]) AND (([tbl Allocations].TargetPID)=[tbl Patterns to delete from Allocation table]![TargetPID])); Chester Kaup Engineering Technician Kinder Morgan CO2 Company, LLP Office (432) 688-3797 FAX (432) 688-3799 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com