• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

Adding bitmap images to access?

K

Kaos

[H]ard|Gawd
Joined
Oct 14, 2003
Messages
1,328
Ive never really used access or had a need to, although a coworker is doing something for her school that requires her to add bitmap images to a database.

Ive never done this before and dont have a copy of access to try to get it by trial and error, is there a simple way to do this?

She would really appreciate it, and so would I because I would be able to help her out.

Many thanks, Kaos
 
Where does she want to add the image? The only rerasonable place I can think where yopu would want to add an image is in a form. If this is the case, go to the top menu and select the drop down "insert". Then select "picture" and point it towards where the picture is stored on the computer. You should be able to move the picture around. Hope this helps!
 
Hartlove said:
You can keep images in a table by making the column type "OLE Object".
Click to expand...

Just remember that Access is very inefficient at storing images, and databases grow very quickly.
 
^When you go to add the images to the database, you can link them instead of embed them.
 
its only going to have 30 images total, and what is the process for linking to images?

She said that when she clicks insert that picture is not in the list.

linking to...would she just need to insert the path? and how would that compensate for being in a folder on a thumbdrive...im in no rush really, i dont work again til saturday and i figure ill grab and edu version from school on friday to mess with.

thanks for all the help so far,

Kaos
 
It would help if we knew what the pictures were for. Are they just going to be just visual additions to forms? Or are you going to want to be able to insert pictures into the database as some element of an attribute?


If you are just trying to add banners to forms, or little pictures here and there, you probably have to embed them. You can add them to a form by clicking the Image button in the toolbox , or Insert Image from the toolbar (as was said earlier)


If you're trying to add a new field to a customer table (for example) that allows you to insert customer pictures, you'd go to the table design view for the customers table, type in a fieldname such as CusPIC, and for the datatype select OLE Object (also as said earlier).

Then you can go to Datasheet View to insert pictures or add it to a form so you can insert pictures from a form. To insert pictures in Datasheet View, just right click on the box that pertains to the CusPIC column of the record you want to insert a picture, and select Insert Object. A dialog will popup, and select the Create From File radiobutton. You can click browse to find the file you want to insert.

Right next to the browse button is a "Link" checkbox. If you check this, it means Access will store the absolute pathname of the file that you're trying to insert. If you're linking to pictures on a thumbdrive, you obviously have to have the thumbdrive in the computer (and make sure that windows detects it as the same drive letter everytime) for the database to link the pictures correctly. If you leave the Link checkbox unchecked, it will embed the pictures into Access and bloat the Access file.
 
Ok ive gotten as far as youve described, when I insert an image it just says "bitmap image" in the field...is this normal?
 
Yep, you won't be able to see the image until you load it on a form
 
You must log in or register to reply here.
Back
Top