[AccessD] Import or Export query between Access DBs

If you can walk her through this over the phone...

First, you create an empty mdb and import the query into that mdb
(File-->Get External Data).  Send her the mdb with the query.  Have her save
it someplace where she knows where it is (preferably the same folder with
her production mdb)

Have her open her production mdb and click File-->Get External Data, etc.  

You might test this on a copy of her original mdb before sending it - but
I've done this with users that aren't afraid of the database container and
it's worked.

What I do for those who can't find 'File Edit View' on the screen is ask
them to stop work, send their production mdb over, update it, and I send it
back.  Turnaround time - just a few minutes.

R
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Wednesday, March 03, 2010 9:07 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Import or Export query between Access DBs

A user of mine needed help w/a query. So, I made a copy of her DB (A2007) to
my machine, so that I wasn't playing w/her live data...and it is quicker
being local, because she is across town. I created a new query, which does
what she wants and I'd like to share it w/her. However, I don't want to copy
over the whole MDB file, because she probably has added to it. I thought I
remembered exporting a single object (query, form, etc.) to another DB, in
the past...or importing from the other end. 
 
Yes, no? How?
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com