DAO : Can't drop Sql Server 2005 table

[Franck]

Hi,
Got problem with DAO and my Sql Server 2005 DataBase.
I can create table from vba using DAO, insert records, read them but
can't drop the table and can't figure out why !

Here is my code (basic!)
*****
Dim db As Database
Set db = OpenDatabase("", dbDriverNoPrompt, False, strConnect)

strSql = "DROP TABLE " & strTmpTable
db.Execute (strSql)

db.Close
*****

I checked the user's rights and it's good. Moreover, ADO works.

Any Help would be most welcome !

 

[Alex Dybenko]

Hi,
try this:

Dim qryd As QueryDef
Set qryd = CurrentDb.CreateQueryDef("")
qryd.Connect = strConnect
qryd.SQL = "DROP TABLE " & strTmpTable

qryd.ReturnsRecords = false
qryd.Execute


--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com