MacRena
asked on
Exporting a query as an MDB
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Just send the SQLstring in an email to where ever and let the receiver paste the string into the Vew SQL window of the query builder.
ASKER
well, the purpose here is to make as simple as possible the creation of subsets of data that can be saved as seperate MDB files.
any ideas how i can do that (using built in tools and not code)?
that's the goal. no code and a seperate MDB.
any ideas how i can do that (using built in tools and not code)?
that's the goal. no code and a seperate MDB.
Why proliferate your disk with a bunch of mdb's when you can accomplish the same within a single mdb and multiple queries. Remember the mdb file is a complete database containing all the objects belonging to that database - tables, queries, forms, reports, ASP pages, macros and modules. You can group your datasets by using the Groups object button on the database window. Click Help, Answer Wizard, and type - Use groups to organize objects in the Database window.
ASKER
so the customer can send out select data to their remote offices based on territory.
they don't want to (nor are they authorized to) give everyone's data to everyone else.
they don't want to (nor are they authorized to) give everyone's data to everyone else.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks lucas911 & GRayL,
your assistance really helped!
mac
your assistance really helped!
mac
Glad to help.