[AccessD] Delete query does not run

Paul Hartland (ISHARP) paul.hartland at isharp.co.uk
Thu Dec 1 09:58:18 CST 2005


Bugger can't think why off hand, but don't think you can use Constants.* or
any .* in a delete query...Think you need to change it to : 

DELETE Constants.PID

FROM Constants

WHERE (((Constants.PID)=[CONSTY]![PID]));

Paul Hartland

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: 01 December 2005 15:47
To: Access Developers discussion and problem solving
Subject: [AccessD] Delete query does not run

Here is the delete query. Get a message of cannot delete from specified
table. Why?

 

DELETE Constants.*, Constants.PID

FROM Constants

WHERE (((Constants.PID)=[CONSTY]![PID]));

 

 

Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799

 

 

No trees were killed in the sending of this message. However a large number
of electrons were terribly inconvenienced.

 

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