MS Access query/deletion issues

[LB]

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

[Doc_Duke]

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.

[Kurt_Bremser]

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.