Converted Accdb to MDB but Images not showing on different computer.


I created a database software on Access 2007 and it includes some images which is supposedly "embedded" which I assumed the images are stored inside the database without needing the actual image files reside in any computer. That is my understanding of Embedded word.

However one of my computers has only Access 2000 and will remain that.

I saved Access 2007 as "Access 2000 Database" and it converted into MDB which works good when run on current computer.

I transferred MDB to other "Access 2000 Only" computer and tried to ran MDB.

I kept getting this same error message on every image file saying "Cannot open image file <name>" making every image property blank.

How I go about on fixing that issue?

Thank you in advance
Ethan L.
(Excuse me if I made any mistake in posting considering this is my first ever post on this site)
Who is Participating?
EthanLConnect With a Mentor Author Commented:
Problem Solved!  (This is relating to any images stored in database that is converted from ACCDB to MDB and tried to run on other computers)

I did -alot- of researching with my 4 computers (thank god for that) and some of them are installed with only access 2000.

So when I created a database in Access 2007 and saved it as "Access 2000 Database". It will convert from ACCDB into MDB. I am sure you are aware of that.

The problem is Access 2007 will leave traces of Access 2007 parts inside MDB.

So when you run MDB on older version, either Access 2000 or Access 2000 Runtime, on different computer. it will gack saying unable to open the image files.

So from my experiements on 4 computers, I finally came to a solution which fixed my problem.

Since computers with only older version of Access wont show images because of traces of Access 2007 inside MDB so I downloaded and installed Access 2007 Runtime on the other computer. It runs great.

I can see all images just fine and work intended.

I tried different solution which works good.

Copy all the modules, forms, tables, et cetera from Access 2007 database into new Access 2000 database and re-linking to images, the images will be still embedded. Save it. Run MDB.

Well that is MY solutions to that specific problem I have. Hope this help anyone. I wish I had thought of that much earlier and save my fustrations :)

Have a great day

EthanLAuthor Commented:

I finally found a link that may be related:

I created table "Images" and created field with OLE Object, then I added image file.

But I do not see a way to use images in table. It still says "Cannot open image file <name>"

How do I use the images from table? How do I bound image in tables to a control (Picture control for example)

I will keep researching. :(

Thanks in advance.
EthanLAuthor Commented:

On that link, it says it only support bitmap form for OLE object storing image.

My table field was showing "PACKAGE" on each image which is unsupported format.

So I tried bitmap image and stored that and it showed "BITMAP" instead of "PACKAGE"

But still doesnt work, still says "Cannot open image file <name>.bmp"

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

sounds like sw issue. maybe you havent got sw that rads that type of bmp file. what is bmp suffix registered to? (look in explorer/view/folder options/file types)
u may need to register it to a app that can open that bmp
EthanLAuthor Commented:
It shows BMP is registered to Paint software.
Good work there. Glad you got it sorted.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.