Delete query in another database

  • Thread starter Thread starter Nan Hauser
  • Start date Start date
N

Nan Hauser

Is there any way to delete a query in another database other than the current
database?
 
Nan said:
Is there any way to delete a query in another database other than the current
database?
Click to expand...


That does not sound like a good approach to whatever you are
trying to accomplish.

For a Jet database, you can use code something like:

Dim db As DAO.Database
Dim qdf As DAO.Query
Set db = OpenDatabase("full path to other database")
db.QueryDefs.Delete "name of table"
db.Close : set db = Nothing

But there are nuances so be sure to check VBA Help on the
OpenDatabase method and QueryDefs collection.
 
You must log in or register to reply here.

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

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Record insert/delete anomaly 0
Delete tables in another database via VBA 7
Open form in another database 5
Am I disturbing a machine in production floor if I access its database remotely? 4
Calling Query from Another DB 1
Access Access Report Works on One Machine but not Another 3
Rename database Object from another Database 2

Back
Top