How do I rid my Access DB of embedded graphics I no longer want? .

[CVICBAK]

(I tried embedding some high resolution graphics scanned images in BMP and
JPG format) in an Access 2000 database to use as the background of some
forms. I ended up not wanting them and thought they were gone as I could not
find any more reference to them in any form properties etc., and continued
with my development and put a lot of work into my forms. However I noticed
my database has swelled to nerly 180 MB and there is hardly any data in it.
I suspect the graphics are still being stored in there somewhere and I can't
find them. I don't want to have to delete and rebuild my forms from scratch
or by coping and pasting objects from a copy. I must have fallen asleep in
class or not read a chapter or something.

 

[Mark Jerde]

It's been a long time since I used Access 2k but here are a couple of ideas
that may work.

1. Compact the DB.
2. Create a new DB and import everything you want.

HTH.

-- Mark

 

[CVICBAK]

!ark Thank You. It was so simple, logical and obvious, and I just missed
it. I normally compact a DB near the end of a project as a final clean up
and just did not think of doing it so early own. More sleep and a break might
have helped too. In the words of Homor Simpson "DOH!" Thanks again.

 

[Mark Jerde]

Mark Thank You. It was so simple, logical and obvious, and I just
missed it. I normally compact a DB near the end of a project as a
final clean up and just did not think of doing it so early own. More
sleep and a break might have helped too. In the words of Homor
Simpson "DOH!" Thanks again.

<g> Been There, Done That, Got The Teeshirt, Wore Out The Teeshirt, Use The
Teeshirt Pieces As Dustcloths...

I have gotten a LOT of help in newsgroups over the years. It's nice to
occasionally be able to give some. ;-) Don't fret about the "DOH!" part.
If you google the FrontPage newsgroups you'll find someone answered one of
my questions more or less like this: "From the 'Window' menu, select 'New
Window'." We all have "brain lock" at times. ;-)

-- Mark