Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 12th, 2006, 11:31 AM
Registered User
 
Join Date: Apr 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Could not delete from specified tables. (Er 3086)

I’m trying to batch delete a series of records, but I’m getting an error that says it can’t delete from the specified table. Apparently something I’m doing is setting it to Read Only. Can’t figure it out. Any part of this code look wrong to any of you?


DELETE DateDiff("d",[field17],Now()) AS Expr1, tblCROVIEW.Field23, HBA_UDSSHIP.SUBENROLLSTATUS, CREDALL.*
FROM CREDALL INNER JOIN ((HBA_UDSSHIP INNER JOIN ContactInfo ON HBA_UDSSHIP.CUSTOMERID = ContactInfo.FACCODE) INNER JOIN tblCROVIEW ON ContactInfo.FACCODE = tblCROVIEW.Field1) ON CREDALL.Field2 = tblCROVIEW.Field1
WHERE (((DateDiff("d",[field17],Now()))>210) AND ((tblCROVIEW.Field23) Between (Date()+120) And (Date()+160)) AND ((HBA_UDSSHIP.SUBENROLLSTATUS)="ENROLLED"));




I want to delete only records that match the codes that meet the criteria of having an expiration date that falls within a certain date range, the expiration date is held in the "tableCroview" table, field23
Field17 = equals the date
Enrolled status is held in UDSShip table

The records I want to delete are in the Credall table




Similar Threads
Thread Thread Starter Forum Replies Last Post
getting Could not load Authorization extension er shivanandk BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 0 February 1st, 2007 01:48 PM
ER dia to SQL schema conversion neerajiiitb SQL Language 1 March 31st, 2006 09:12 AM
Using Asp to Add/Delete Tables in a SQL database? morpheus Classic ASP Databases 2 April 23rd, 2004 07:59 AM
Delete from 3 tables collie SQL Server 2000 1 March 24th, 2004 11:49 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.