[AccessD] Can't delete records from this table

Jim Lawrence accessd at shaw.ca
Sun Aug 19 11:12:40 CDT 2007


Hi John:

You can not delete on 2 or more tables simultaneously, in a single sequel
statement just like you can not add to 2 or more tables... without coding
that is.... or using cascading deletes... forget I said that! 

Jim  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, August 16, 2007 2: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