DeleteObject not found?

[AC5FF]

According to Microsoft (probably my first error in trusting them) DeleteObject is still available in Access2016. I'm not sure why, but I'm not seeing it or I can't even type it in.

Honestly I ran into the same problem when I was using the ImportExport Text command in the macro. Only reason I got that to work was by copying it out of a pre-existing macro.

Is it possible I do not have something installed correctly - maybe missing some add-on from when Office was installed?

All I'm looking to do is delete an ImportErrors table.

Now I know that this can be a fairly simple task in VB - but I'm no VB expert; not even a nOOb at it. I'd just prefer to stick with the macro option at this time.

TIA

 

[RogerCooper]

Did you click "Show All Actions" on the "Design" tab?

 

[arnelgp]

Yup, just check on
my A2016 x64, its there alright.

you an use SQL query to delete the table:

DoCmd.RunSQL "Drop Table tableName;"

 

[AC5FF]

DoCmd.RunSQL "Drop Table tableName;"

I may try this!?! The tablename is OutFileReport_ImportErrors
So would this be DoCmd.RunSQL "Drop Table OutFileReportImportErrors"
Including quotes?

And I was sure I clicked on 'Show All Actions' but I re-opened the dbase and clicked it again and now DeleteObject is showing!

I need a new computer! LOL

Thanks all!