H
hmbhuss1
We have a system where numerous Access databases send out excel files to
clients automatically using the DoCmd.SendObject command. (We also have
databases which use the Outlook API and CDO but the failure here occurred on
one using the SendObject command). We had an email go out with 4 attachments
on it. One attachment was appropriate to the database that send the email
but the other 3 attachements were from databases that had sent out files the
previous day. Additionally, the other 3 Excel files had been renamed to have
the name of the query that was being sent out by the database with _tbl1,
_tbl4 and _tbl8 appended onto their name, before the .xls. So the query
going out was called Client_New08_tbl.xls. The other files were
Client_New08_tbl1.xls, Client_New08_tbl4.xls and Client_New08_tbl8.xls.
We found the actual excel files that these came from and they had all been
made in a 10 minute period on the previous day. Just prior to that time
about 25 of these databases all stacked up and I had to crash them and re-run
them manually. Looking at the Temp folder after the multiple file email had
gone out, I noticed 2 CDB*.tmp files sitting there. These appear to be the
temp files that send object makes when it is creating the excel file to
attach to the email (I'm guessing). I'm wondering if in this crash there
were temp files left in the folder that had the same name as the temp file
that was being made the next morning, but beyond that I have no clue as why
they would get renamed and attached.
Any help would be greatly appreciated.
clients automatically using the DoCmd.SendObject command. (We also have
databases which use the Outlook API and CDO but the failure here occurred on
one using the SendObject command). We had an email go out with 4 attachments
on it. One attachment was appropriate to the database that send the email
but the other 3 attachements were from databases that had sent out files the
previous day. Additionally, the other 3 Excel files had been renamed to have
the name of the query that was being sent out by the database with _tbl1,
_tbl4 and _tbl8 appended onto their name, before the .xls. So the query
going out was called Client_New08_tbl.xls. The other files were
Client_New08_tbl1.xls, Client_New08_tbl4.xls and Client_New08_tbl8.xls.
We found the actual excel files that these came from and they had all been
made in a 10 minute period on the previous day. Just prior to that time
about 25 of these databases all stacked up and I had to crash them and re-run
them manually. Looking at the Temp folder after the multiple file email had
gone out, I noticed 2 CDB*.tmp files sitting there. These appear to be the
temp files that send object makes when it is creating the excel file to
attach to the email (I'm guessing). I'm wondering if in this crash there
were temp files left in the folder that had the same name as the temp file
that was being made the next morning, but beyond that I have no clue as why
they would get renamed and attached.
Any help would be greatly appreciated.