>Yes, I had also tried the connection object with no success. :(

The only other thing I can think of is to check the connection object's error collection for any messages.

Like I said, I have no problems using a temp table with a single # as you are trying to do, with MDAC 2.6 and SQL7 SP3. Although I have full rights to my test SQL Server.