importing access objects into a new blank database

[Paul James]

I'm trying to create a new Access database by importing all the objects from
an existing database. Specifically, I'm importing all
- tables
- queries
- fomrs
- reports
- macros and
- modules.

However, when I try to open the new mdb file, I get a message saying it
can't find a custom toolbar that it expects to be there. How can I import
the custom toolbar from the old database into this new database?

(The reason I'm doing this is that the existing database has been in
production for several years, originally in Access 97. Since it was
originally built, it has gone through several iterations of updating, with
various objects being created and deleted. During that early period, it
also got corrupted several times, and I had to recover it. I'm not sure
about this, but I'm thinking there might be some miscellaneous debris left
over from all the work that had been done, and that I might have a better
database if I go through the process I described above; that is, by starting
with a new blank database and simply importing all the identifiable objects
from the old one.

At times in the past when I've tried to do something that I thought up
myself like this, experts have pointed out that either there was no
advantage to be gained by doing it, or that it was a massive mistake that I
would regret for the rest of my life. So my question in this regard is
this - can I accomplish anything in what I'm trying to do, or is this a
waste of time, or worse, will I come to rue the day when I did this?)

Thanks in advance,

Paul

 

[ChrisJ]

Custom toolbars: there is an "Options" button on the import objects dialog
(at least in A2K)

Comment: I do this every release to our clients.
It can reduce the size of large DBs by 10s of MB even after compacting.

 

[Ken Snell [MVP]]

Custom toolbars: there is an "Options" button on the import objects dialog
(at least in A2K)

And in A2K2.

 

[Paul James]

there is an "Options" button on the import objects dialog

Ah - there it is. Thanks, guys.

Paul

 

[Joan Wild]

However, when I try to open the new mdb file, I get a message saying
it can't find a custom toolbar that it expects to be there. How can
I import the custom toolbar from the old database into this new
database?

One of the reports or forms or startup code is looking for this toolbar.
Open your database and go to File, Get External Data, Import. Find your old
database and click on Import. At the dialog where you select the objects
(don't select any), click on Options and you'll see the checkbox to import
menus/toolbars.

 

[Paul James]

Yes, that's what I was missing.

Thanks, Joan.

 

[Paul James]

My belated thanks for this additional and helpful information, Joan.