topic MS Access query/deletion issues in SAS Procedures

MS Access query/deletion issues

LB — Tue, 17 Jun 2014 21:02:20 GMT

Hi all;

I have a general question regarding MS Access in respects to deletion/update queries-

When I attempt to delete multiple deletions or updates that are grouped (by a medical record number (mrn) for example)-I cannot make one whole deletion query-

It results in an error that results in a rollback of the data. Instead I must create a macro that cycles through every MRN. When you have 4,000 of them-this becomes a huge timer killer.

Any suggestions on resolving this. Thank you.

Lawrence

Re: MS Access query/deletion issues

Doc_Duke — Wed, 18 Jun 2014 02:08:22 GMT

Are you using SAS to do the work in MS Access? Assuming yes, perhaps you could share the code and the error message. You could also go to the SAS/Access manual for your version of SAS and look at the diagnostics available to you so you can see exactly what SAS is passing to Microsoft Access.

Re: MS Access query/deletion issues

Kurt_Bremser — Wed, 18 Jun 2014 06:10:46 GMT

Seems you violate the integrity rules in the Access database when you do the mass deletion/update. Or you run into too many pending operations before you "commit". I suggest to do the same operation (quasi-)manually in Access to determine when you run into obstacles.