Exporting a query as an MDB
Posted on 2007-08-02
i know how to use TransferDatabase, but i want to know how to Export a query using built-in tools, and not in code.
i tried File/Export and exporting it as an MDB but it tells me the database doesn't exist and i should check my spelling. (although it exported as an XLS no problem).
i'm in Access 2000 but several years ago at a MS launch (maybe for 2002, i don't recall), i heard them talking about "perpetuating a recordset", but i don't know what that means.
so the question is:
how do i use File/Export while in a query, and save it as an MDB?
or what tool is available to do that?