Re: [MS_AccessPros] Error: Could not delete from the specified tables (MS Access 2010 or 2013)

 

John,

The code was created with: Design View Query Type: Delete.

Do you know if is a glitch in MSAccess 2010/2013 regarding this issue?

Also I am having the same error with the following SQL View code:

DELETE tblCity.*, tblCityStateZip.Zipcode, tblCityStateZip.City, tblCityStateZip.State
FROM tblCityStateZip RIGHT JOIN tblCity ON (tblCityStateZip.State = tblCity.State) AND (tblCityStateZip.City = tblCity.City) AND (tblCityStateZip.Zipcode = tblCity.Zip)
WHERE (((tblCityStateZip.Zipcode) Is Null) AND ((tblCityStateZip.City) Is Null) AND ((tblCityStateZip.State) Is Null));

Thanks

Norbert

__._,_.___

---

Posted by: drnorbert@msn.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___