sendObject sends too many files

[Jay]

Does anyone have any input on this oddity? I am using an Access macro
to run a query and send a file as an attachment. The query runs, the
xls is sent. On a few random occasions, the macro runs, attaches the
xls, and also attaches files that were sent previously via the same
process. If my naming convention for the file I intend to send is:
newfile.xls, these rouge files will be attached as newfile01.xls,
newfile02.xls etc.
The extra files are not located on the filesystem anywhere - I checked
hidden files, the OLK directory, etc.
So I'm curious about:
1. How this is even possible - I thought sendobject could only send
one file.
2. Given that it's obviously possible, where would sendObject be
getting these files and what might be happening to make it continue
past the point of completing the query and creating the proper xls
file.

Any feedback at all would be greatly appreciated.

 

[a a r o n _ k e m p f]

wow it sounds to me like you're hitting some sort of Jet bug... when
that happens-- I think that it's best to move to SQL Server

do you know that SQL Server Reporting services can email reports
results in an automated manner-- without writign any code?

 

[BruceM]

You can ignore Aaron. His reply is not relevant to your question.

Are you really running a macro, or is it VBA code? If the latter, post the
code.

 

[Jay]

You can ignore Aaron.  His reply is not relevant to your question.

Are you really running a macro, or is it VBA code?  If the latter, postthe
code.

It's really a macro. Maybe not the best way to go, but it worked
flawlessly until we moved the process to XP/Office2003/ (from w2k/
office2000). Thanks.