Well, yes there is a specific source from where I got these examples. They are part of my small app to move research reports from email to database.

It sometimes...

This one is to store the data

Dim strStream           As ADODB.Stream

Set strStream = New ADODB.Stream

strStream.Type = adTypeBinary

strStream.Open

strStream.LoadFromFile sFileName

DoEvents

Fields("MsgAttachment").Value = strStream.Read

....

This one is to retrieve the data

Dim strStream   As ADODB.Stream

sql = "SELECT MsgAttachment...

Now that's a shameless plug

I haven't found such a documentation. But looking at the article I've mentioned didn't make the answer that difficult anymore.

What about telling your boss, that a mail is a kind of CYA strategy.

That will be the only way to prove that your application is working as it should....

Try to explicitely name your columns in the view, not SELECT...* FROM...

Basically if I remember correct, there is no equivalent to Last or First in T-SQL. This is simply like returning the last or first row in a resultset. And unless...

yes, there is.

Take a look  at DBCC PINTABLE or sp_tableoption in BOL

Have you already searched this site?

IIRC, there is a script somewhere here, that compares data. Not sure if in tables and/or resultsets.

Aah, that's my turn again

Read this http://www.sommarskog.se/dynamic_sql.html and decide for yourself which way to go

not really

can you help me with an example?

No problem with me, as long as all post are of formal and textual quality.

Hi Andrew,

what exactly do you mean by 'formatting' ?

Not a solution, but just a note.

Wouldn't sending a mail be better?

I've made the experience, that if you don't explicitely tell your users about sending a message, they commonly close this nasty...