Delete tmp table from back-end databese

[paukste]

Hello,

I have FE/BE databases. I want to delete tmp table (BE) after import data to another table from fron-end database.

I've tried to use following code:

CurrentDb.TableDefs.Delete "[;DATABASE=" & DBFile & ";]." & TableName & ""

where :
DBFile = "C:\a.mdb"
TableName ="table1"

but I get error "Item not found in this collection"

Maybe somebody has solution.
Thank you

 

[PHV]

I'd use SQL code (DROP TABLE)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[paukste]

Thank you. It worked great.