Last post Sep 10, 2009 03:25 PM by Mikesdotnetting
Sep 10, 2009 01:07 PM|bbxrider|LINK
the code is basic
strAlDbConn = "provider=microsoft.jet.oledb.4.0;" & _
"data source=" & dbDir & ";"
Set alConn = CreateObject("adodb.connection")
Dim objCommand, objCatalog
Set objCatalog = CreateObject("ADOX.Catalog")
objCatalog.ActiveConnection = alexaConn
running xp pro, processor is 1gb speed and memory, the access db has about 20 tables, nothing else has the db open etc
Sep 10, 2009 03:25 PM|Mikesdotnetting|LINK
First, you are using classic ASP (pages end in .asp). This forum is for ASP.NET (pages end in .aspx) They are completely different. Second, why are you using ADOX to delete a table? Why not simply use DDL?
sql = "DROP TABLE uniquedates"
Future calssic asp questions should be asked here: