Transfer Many Tables From One DB To Another

[Guest]

I have a form that includes a cmd button called “Transfer My Notesâ€.
There will be an existing DB in the user’s computer which will need to be
replaced with a new DB. In the New DB the current option is for the user to
do the “Get External Data\Import\Look in\Select the DB where the tables are\
Click on Import\ On the Import Objects window click on Select All (Tables)
and click OK. This transfers all tables to the new DB.
Getting people to even try to use the DB has been like pulling teeth, so if
we can make it easier for them to “seamlessly†transfer their personal notes
to the new DB version by doing one click, this will be huge.
With my minimal ACCESS knowledge, I toyed around with the MACRO feature
“TransferDatabaseâ€, but I found this is only good for one table at a time.
The Get External Data seems to be the answer but I just don’t know how to
bottle it up into a command button that will do it automatically for the
user.
I sure hope I explained my self right.

Regards.

 

[Roger Carlson]

Why not leave the "Notes" tables in a separate database on their hard drive
and just link them into your new DB?

If your file structure is the same as theirs, i.e. you make sure the DB is
in C:\MyDatabase (or something), you can link the notes tables database on
your system and when they copy it to their system, their table will
automatically be linked.

On the other hand, if you can't guarantee where they've put the database,
you can add code that will automatically relink their Notes database tables.
On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "RelinkOnOpen.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Thank you for your reply Mr. Carlson.
Your idea of creating a separate DB with just the notes is a good one. But
the only snag with this is that in the NEW DB there will be instances where
we will need to create a new table or two allowing for the user to associate
notes with the latest changes. So we will distribute the new DB with either a
couple of new My Notes Tables or none at all. This is why I see the Get
External Data as my answer, I just do not know how to tell the system to
import all the tables at once. The ACImport so far has allowed me to do one
by one and I have approx 65 tables. I guess I can duplicate the Macro over
and over but I was hoping for some sort of one line code to include a range
of tables to be imported.

If you have any other ideas I am listening. I will visit your website to see
if what you mentioned earlier can help me.
Thanks