Embedding Pictures. - Microsoft Access / VBA

I have a database that I have done for a friend. It works on my computer, where I designed it and copied it to his laptop where it works but somehow, whenever i try to embed a photograph (.bmp) in his version, it just shows up in the Bound Object Frame with the File name, rather than as a Picture. I have checked the difference between all the settings in the two databases that I can think of but just cannot see what has been reset. Can you advise???

Also, if I try to Compact the database, the program crashes. I am running Office 2003 and the database is created in 2000 mode. It is getting big, 440,000kb. If I take all the photos out. It will compact down, so I suspect the problem has something to do with having a large Database. (which is why I want to compact it in the first place.)

Oct 26 '06 #1

Subscribe Post Reply

3464

NeoPa

32,556

Expert Mod 16PB

The only way i know to change a linked picture to an embedded one is to right-click on the item itself, choose 'Insert Object...' and load the file again, being careful to make sure the 'Link' checkbox is left clear.

Oct 26 '06 #2

Bevan Moore

The only way i know to change a linked picture to an embedded one is to right-click on the item itself, choose 'Insert Object...' and load the file again, being careful to make sure the 'Link' checkbox is left clear.

Thanks but I have tried that. The photos I am using are JPG's converted to bitmaps through Photoshop Elements 3. It has worked in the past and still works on my computer but not on my friend's laptop. I am converting them on his laptop first.

Oct 26 '06 #3

pks00

280

Expert 100+

My personal recommendation is to use blobs
U store as a blob then extract the image from the blob, then use the picture control to display it
Also uses a little less space than ole objects
http://support.microsoft.com/?kbid=210486

Ive used blobs and for anyone wanting to store images, this is what I always tell them to do

You may also find this a interesting read
http://www.jamiessoftware.tk/articles/handlingimages.html

Oct 26 '06 #4

PEB

1,418

Expert 1GB

And about Visualizing Corel Draw objects in 10 to 40 records /in each record different Corel Draw file that is outside of the database/ what can you suggest me?

For the moment I'm using OLE linking for the concerned rows... But it's very slow! 10 seconds are needed to link the corel drow to the respective record

Help appreciated!

My personal recommendation is to use blobs
U store as a blob then extract the image from the blob, then use the picture control to display it
Also uses a little less space than ole objects
http://support.microsoft.com/?kbid=210486

Ive used blobs and for anyone wanting to store images, this is what I always tell them to do

You may also find this a interesting read
http://www.jamiessoftware.tk/articles/handlingimages.html

Oct 27 '06 #5

Similar topics

Extending/Embedding python

by: Alicia Haumann | last post by:

I accidentally sent this to webmaster@python.org, so this could be a duplicate if "webmaster" forwards it to this list. :{ Hi, there. Thanks for any help that can be offered. I've been...

Python

Embedding Python in Windows tutorial?

by: Roose | last post by:

With some googling I have found these resources: http://docs.python.org/ext/win-dlls.html http://www.python.org/doc/faq/windows.html I have a large Win32/MFC/C/C++ application that has an...

Python

Embedding: Question about modules

by: smilechaser | last post by:

Hi All, A question about embedding: If I take the example code on embedding (Section 5.3 of Extending and Embedding the Python Interpreter 2.4) and add the lines: PyRun_SimpleString("import...

Python

Pictures in MySQL

by: JakeC | last post by:

Hey all, I'm currently redesigning a website that a friend and I started about a year ago. It is a daily surf report so when choosing the best script/language to use for the new design, I found...

MySQL Database

Help please! Linking, showing, but not embedding images

by: theo.bruening | last post by:

Hello all. I hope someone can help me here. I need to make a db on many pictures, however, if I OLE them, the access database grows hugely. If I only hyperlink them, I can't view them. is there...

Microsoft Access / VBA

Tree View File Browser

by: Lyn | last post by:

What is the best way to import a picture (bmp format) via VBA from a Windows file and embed it into a Bound Object Frame (and thence to an OLE Object in a table)? I found an MS knowledge base...

Microsoft Access / VBA

embedding images into e-mail in pure asp.net

by: Ersin Gençtürk | last post by:

is it possible to embedd images as inline images into e-mail in pure asp.net ? I don't want my pictures sent like attachment , but I want to send them as inline pictures.Is there any way to do...

ASP.NET

statically embedding a stylesheet within another stylesheet

by: hq4000 | last post by:

Given AStyleSheet.xsl : <AStyleSheet> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns="http://www.mytest.mytest2.mytest3.com" version="1.0"> <xsl:output method="xml"...

.NET Framework

beginner questions on embedding/extending python with C++

by: Qun Cao | last post by:

Hi Everyone, I am a beginner on cross language development. My problem at hand is to build a python interface for a C++ application built on top of a 3D game engine. The purpose of this python...

Python

Storing pictures in database

by: Zeljko Bilandzija | last post by:

Hy, could someone help me in this: In design mode, i want to put pictures in database. I made column named pics, and its type as image. How can I put pictures or some address of these pictures...

Microsoft SQL Server

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp