Renato, this is a very useful and interesting article. Can you tell us how this code from your example works? It looks like you are evaluating the status of...

Wouldn't it be more effective to either call two different stored procedures (one for wide date ranges, one for narrow) or use the HINT option to force the JOIN type?...

Functionality aside, there was a significant customer miscommunication issue which happened with the release of v2.0. Confusing your customers is bad business.

Hopefully v3 is so great that we can overlook...

This was also cross-posted in the DTS forums. I believe the thread there answers the question pretty completely.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=247818

Why not have the process that updates the view also initiate creation of the text file? In other words, if there is a front-end or batch process that modifies the...

Suresh, there are three approaches:

1) preferably, move the data into SQL Server, and link the tables back into Access. You can even rename the linked tables in Access back to...

Kevin, probably the user ID which the job runs under doesn't have privileges on that remote server. I.e., if you run the package directly, it runs under your login. If...

Some likely causes for this error message are discussed in the link below (I found this by simply Googling your error message). Good luck!

http://systemwebmail.com/faq/4.3.11.aspx

System.Web.Mail is working correctly, and is...

I guess working at 2 AM on a "very large system designed by someone else" can really put a person on edge.

I guess I'll stay out of this thread...

Minh, which line of your code throws that error?

It seems like you'd do well to just use an intermediate table to hold the results of these missing records. I take it this is some kind of ad hoc,...

You really can't beat EditPad for versatility (http://www.jgsoft.com). It has built-in libraries for every conceivable flavor of SQL (including T-SQL), and also handles any other kind of text editor...

Minh, the email you have in this example is a string, but you do not have it in quotes.

Actually, there are lots of options. This is probably a non-exhaustive list:

• Link VIEW into Access using ODBC connection
• Import VIEW into Access using ODBC connection (it will turn into an...

I think the way to do this is to open a recordset which contains the data to be placed in the message body. Then simply use DoCmd.SendObject to send the...