Kaup, Chester
Chester_Kaup at kindermorgan.com
Thu Aug 16 16:54:09 CDT 2007
You might want to change it to YES and run the delete query. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Thursday, August 16, 2007 4:41 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Can't delete records from this table Nope. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester Sent: Thursday, August 16, 2007 5:25 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Can't delete records from this table 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 -- 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