Replace a query Part2

C

ChoonBoy

Thanks to Dirk Goldgar, MS Access MVP, I managed to solve my earlier question
with the codes below.

DoCmd.TransferDatabase acExport, _
"Microsoft Access", "C:/Test/database.mde", _
acQuery, "qSales", "qSales"

How do I close the database.mde before running the above codes. This is to
make sure that "qSales" is not having the focus while trying to replace it.

Thanks for any help.
 

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

Top