Kaup, Chester
Chester_Kaup at kindermorgan.com
Thu Aug 16 16:24:38 CDT 2007
Do you have in the query properties unique records set to YES? -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Thursday, August 16, 2007 4:17 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Can't delete records from this table I have a table where if I create a simple query - join tblX to tblY on PKID, turn into delete * - it gives me the message "can't delete records from this table". Yet if I turn it back into a select query I can highlight records and delete them. Any ideas why? John W. Colby Colby Consulting www.ColbyConsulting.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com