Cannot delete a table 2

[ooch1]

Hello,

I am importing some text into one of my tables and as a result i get a new import errors table.
As part of my import code i have used the following line
to try and delete this table.

DoCmd.DeleteObject acTable, "[Gas_Hull_COT_PortAnlys_ImportErrors]"

However, when i then run the code, i get an eorror message stating that microsoft access cannot find the object, even though when i then look at the database it is most definitely there.

Can anyone show me how i can delete this table???

OOch

 

[SJMcAbney]

Take out the square brackets.

Stewart J. McAbney | Talk History

 

[PHV]

And this ?
DoCmd.RunSQL "DROP TABLE [Gas_Hull_COT_PortAnlys_ImportErrors]"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ooch1]

Guys - A Star for both of you, even though i should have spotted that myslf!!

OOch