[AccessD] Can't delete records from this table

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
turn into delete * - it gives me the message "can't delete records from
table".  Yet if I turn it back into a select query I can highlight
and delete them.  

Any ideas why?

John W. Colby
Colby Consulting

AccessD mailing list
AccessD at databaseadvisors.com
Website: http://www.databaseadvisors.com

More information about the AccessD mailing list