[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
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





More information about the AccessD mailing list