有关使用临时表的问题
程序如下:
Option Explicit
Dim cc As New ADODB.Connection
Dim rst As New ADODB.Recordset
Private Sub Command1_Click()
cc.Execute "select top 1 * into #lls from jc_bmxx"
MsgBox 1
cc.Execute "select * from #lls"
MsgBox 2
cc.Execute "select * from #lls"
MsgBox 3
Set rst = cc.Execute("select * from #lls") '如果去掉这句,下句不会出错!!
MsgBox 4
cc.Execute "drop table #lls" ' ??这句话会出错,提示说“#lls 在系统目录中不存在
MsgBox 5
End Sub
Private Sub Form_Load()
cc.ConnectionString = "....................."
cc.Open
End Sub
为什么?请指教