Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete Query--Jet Error 3086

Status
Not open for further replies.

alley

Programmer
Feb 8, 2000
51
US
I have a select Query that selects job numbers based on a 'Purge up to' date, and a delete query that uses the first query jobno's to select and delete from 2 detail files - job tasks and job employees.&nbsp;&nbsp;I do not delete the job headerfile, the source of query #1 jobno's.<br><br>It selects the correct job numbers, and then gives me the error.&nbsp;&nbsp;This error states the failure conditions, but none of them apply --<br>read-only use, and permissions.&nbsp;&nbsp;Neither are true.&nbsp;&nbsp;Anyone know what is going on?&nbsp;&nbsp;Not supposed to delete from 2 files at once?&nbsp;&nbsp;Do the separately?<br><br>alley
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top