Insert Bitmap Help!!!!!

I am fairley new to building a data base. The database that I built records
information on property owners water service. In my datatbase I made a place
for drwaings; each owner has a seperate drawing but not all owners need a
drawing. The drawing's are use for water vavles that may be hard to find or
trace. When I first built the data base I had no trouble inserting the
scanned in drawings into the correct owner address. I scanned the image in
and saved it asa bitmap and then inserted. Since we had a crash of the
database and now I am unable to insert a bitmap into the drawing. Everytime I
get a drawing inserted it shows up on every account. My problem is it has
been about 2 years since I built the database and I can not remember how to
insert tje picture. Do you do a bound, unbound or what. I have the area for
the drwaing labeled drawing.

scott wrote:
I am fairley new to building a data base. The database that I built records
information on property owners water service. In my datatbase I made a place
for drwaings; each owner has a seperate drawing but not all owners need a
drawing. The drawing's are use for water vavles that may be hard to find or
trace. When I first built the data base I had no trouble inserting the
scanned in drawings into the correct owner address. I scanned the image in
and saved it asa bitmap and then inserted. Since we had a crash of the
database and now I am unable to insert a bitmap into the drawing. Everytime I
get a drawing inserted it shows up on every account. My problem is it has
been about 2 years since I built the database and I can not remember how to
insert tje picture. Do you do a bound, unbound or what. I have the area for
the drwaing labeled drawing.

You may be reaching the size limit of Access if you've stored
a large number of images in the database. The limit is 2 gig.
Better to place the images in a separate directory and include
a link to it in the database or use VBA to display
the images. See the link below

http://office.microsoft.com/en-us/as...802251033.aspx

gls858