If this is for a Jet database, try wrapping the date in # signs, ie:

"HAVING (((tblLinkRequest.DateSent=#" & Date() & "#)));"

An alternative, if this is just for reporting purposes, is, in Access, in the detail_format event, to change the font size depending upon how much data is in the memo....

What I am saying is to bypass the EM and go to DOS.  There, use the DTSrun command.  Does that work? 

I have had to abandon all scheduled jobs that...

It could be -- You may have the wrong driver for your version of Ingres -- apparently there's three main types of Ingres databases -- the original, Ingres II, and...

I have had this error message when attempting to run a dts package connecting to Oracle when the package was designed on a computer with the Oracle drivers but I...

Is is possible that your Ingres table has a column of a custom datatype that SQL Server has no known equivalent for?  Or a size that SQL Server can't handle?...

No, it isn't a domain account.  It is an Oracle account only.

Copying the job to AT scheduler doesn't work... it still runs under the job's security. (AT Scheduler is a...

I posted a long message on this yesterday, but it isn't showing up.

Here's the sp itself, you have to dig through Microsoft to find sp_send_cdosysmail and then add the attachment...

Unfortunately, the image didn't come over.

Using my account to run the job should work, even though my account has to use oracle logins to get into the oracle database?

To create...

Unfortunately, I'm using VPN to get to the sql server and am using sql server security.  I also have an NTDomain\Username I can use, and my other users are using...

What happens when you do only (a or b) and c?  Meaning skip one of the first two...  Does c run then or does it still not run?

I'm sorry, I don't quite get your meaning...

Quote: As soon as I saw this I copied the DTSRun /......... (VERY LONG STRING) into a scheduled task, created an account...

For a purely DTS solution, you can also use the stored procedure 'sp_send_cdosysmail_attachment' which can be found on the microsoft knowldegebase, and you use it in an execute sql task...

Might you have a zero-based list and a 1-based loop, so that the last item never gets accessed? (or something along those lines)

I mean, what happens if you do the...

Yes, I can ping the oracle server.  The dts package runs fine (including connecting to Oracle) as long is it isn't run from a job. I don't get any errors...