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.
gls858 - 11 Oct 2006 19:58 GMT
> 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
[quoted text clipped - 8 lines]
> 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/assistance/HP052802251033.aspx
gls858