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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete query fails with 'read only file' error

Status
Not open for further replies.

alley

Programmer
Feb 8, 2000
51
US
I have 3 files.. Job Headers, Job tasks, and Job workers, one to many on the last two from the header file, not cascaded.<br><br>The first query is a simple select, finding job numbers with dates less than a 'Purge Up To' parameter, then 3 delete queries matching the job numbers to delete the tasks and worker records, and finally a delete on the header file.<br><br>Individually, the deletes work, each asking for the purge to date, but if I put them all in one macro they fail with a 'read only' error.<br><br>The chances of the user putting in the same date for each query is a big weakness, and cascading the delete from the header file is even more dangerous.<br><br>The 'read only' error doesn't make sense, unless it is referring to the files Access opens itself.<br><br>Any suggestions?<br><br>alley
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top