Copying Reports

[Mike C.]

Hello.

I have recently finished rebuilding a database that
someone else created. Basically, I took the old database
and updated the forms, tables, code, etc. The old
database contained about 100 different reports. While I
was designing the new databae, the reports in the old one,
which users were still useing while I worked on the new
one, were changed, updated, etc. Now I want to copy these
reports over to the new database (which contains all of
the old, un-updated reports as well). How do I go about
doing this?

I tried importing all of the reports from the old database
to the new one, thinking it would overwrite them, since
they technically all have the same names, but all it did
was copy the reports and put a '1' after the name. Is
there a way to select all the reports and delete them THEN
import them, or do I need to delete each and everyone
individually?

Any help would be appreciated.

mc

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Easy answer is change the name of the reports w/ the 1 suffix, by
renaming the report & deleting the 1 suffix. Access will "tell" you
there is another report w/ that name "Do you want to overwrite?" Hit
the Yes button. The old report will be removed.

Short answer, long process: write a routine that drops the report
objects and renames the reports w/ the 1 suffix. I used to put the
names of the objects I wanted to do something to (delete, rename,
etc.) in an array and then just loop thru the array doing that
required "thing."


MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQBgrqoechKqOuFEgEQLGowCgn+T/W7yCjhLwrAWB/CqxRnAX9/gAn29j
1CHXzm4QcsG2vmIbPkjYVIGD
=vNNE
-----END PGP SIGNATURE-----