Fruitless; Deleting a table in Access vba code.

[Newby]

I trying to Delete a table code. I found an example online at the following site http://nandeshwar.info/2007/07/18/ac...cess-database/. But, this solution requires me to select DAO 3.x. When I try to select that reference, I getg "Name conflicts with exiting module, project or object library". Currently by database has MS Access 12.0 Object Library select. When do you have to select a library? Can you have more than one? Can to chance them?



newby

[RuralGuy]

DAO is the default reference for ac2007. You do not need to select it.

[dreday]

You can also run an sql statement: Docmd.RunSQL "DROP TABLE X"