Response to Joan Wild

[E. Alan Jankovic]

I can't reach you directly at your email address for some
reason.

I would agree with the new table idea, but this is run on
a daily basis for over a year and it has only occurred 4
times. I did use the delete and append in another
application instead of the make table, but it seems as
though the security should not change. Thanks for your
comments.

 

[Joan Wild]

I would agree with the new table idea, but this is run on
a daily basis for over a year and it has only occurred 4
times. I did use the delete and append in another
application instead of the make table, but it seems as
though the security should not change. Thanks for your
comments.

Your user wouldn't need any permissions on the table, if you used a delete
query (set to run with owner permissions), and then ran an append query
(also set to RWOP).