[AccessD] Delete query does not run

Could Constants be a reserved word by any chance? Try putting it as
[Constants].
--
Andy Lacey
http://www.minstersystems.co.uk




--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Subject: [AccessD] Delete query does not run
Date: 01/12/05 15:49


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

________________________________________________
Message sent using UebiMiau 2.7.2