Response to Joan Wild

  • Thread starter Thread starter E. Alan Jankovic
  • Start date Start date
E

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.
 
E. Alan Jankovic said:
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.
Click to expand...

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).
 
Back
Top