First - great article!

Minor issue with implementation - maybe somebody has experienced this too? When the data is posted from my query into the excel sheet, it doesn't start posting...

Yes its set to autogrow, and has unlimited growth. Its currently has an available size of 50mb.

Thanks!

I was reading about that - but I got the impression that was something that had to be done inside sql server. I need to check how the locking is...

They shouldn't have been, but of course I can't guarantee that they weren't...

Thanks!

I *am* using an ADP. Thanks!

Thanks to everyone for your suggestions! I'm going to try the bcp suggestions first b/c franky, I need dynamic aspects to this file creation and I dislike activeX scripts. But,...

Thank you for the suggestion - I was hoping to eliminate a rather large section of code.

Here is something else that worked (I just discovered)

set @execution = 'exec master..xp_sendmail...

Thanks everyone for your suggestions! I ran into this suggestion on another website and so far it 'seems' to work - using

Environ("username")

captures the username I was looking for. I'm...

I'll take you up on that b/c I'm just starting, and have been doing T-sql for so long that all my VB skills (much less web programming) are completely rusty....

I have been delving heavily into VB.NET myself as a way to get away from Access, b/c of its 'issues' - like the ones you mention.

I just hope they get...

*The only workaround I have been able to come up with is to open a recordset based on a command and then assign that recordset to the recordsource of the...

Thank you very much! Setting the command timeout to zero seems to have solved the problem.

The majority of that time (82 seconds) seemed to be from scanning clustered index.

Code:

Sub ReleaseHold()

Dim cmd1 As New ADODB.Command

Set cmd1.ActiveConnection = CurrentProject.Connection

cmd1.CommandText = "delete from swbt_summary"

cmd1.Execute

cmd1.CommandText = "Insert into swbt_summary...

It ran fine (82 seconds) in query analyzer, so I'm not sure the execution plan will hold any answers to why it hangs when the same query is posed to...

I have tried running it as a stored proc and gotten the same result. I will run it in query analyzer next and see if I can see anything. Thanks.