deleting a table in an other database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know how to delete a temp table i create in the same Batabase. I m having
problem deleting a table in an other database does any body hase an exemple
how to do it
Thank you
 
I usually use DAO:

Dim dbOther As DAO.Database

Set dbOther = OpenDatabase("C:\Folder\File.mdb')
dbOther.TableDefs.Delete "NameOfTableToDelete"
Set dbOther = Nothing
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record insert/delete anomaly 0
Delete tables in another database via VBA 7
How to export table from outlook into ms access table? 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Rename database Object from another Database 2
delete record from external database 6
Allen Brown's audit log code "insert" problem 0
Table to table 2

Back
Top