Solved

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

Posted on 2009-04-08
6
989 Views
Last Modified: 2013-11-05
Question;

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)
0
Comment
Question by:EthanL
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 

Author Comment

by:EthanL
ID: 24104038
Update:

I finally found a link that may be related:
http://office.microsoft.com/en-us/access/HA011472041033.aspx

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.
0
 

Author Comment

by:EthanL
ID: 24104100
Ahh

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"

:-(
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 24109020
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
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

Author Comment

by:EthanL
ID: 24109390
It shows BMP is registered to Paint software.
0
 

Accepted Solution

by:
EthanL earned 0 total points
ID: 24111577
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

~EthanL
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 24111657
Good work there. Glad you got it sorted.
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS ACCESS VBA FORMATTING 9 62
Database (Access Table) Security Access 8 57
Need Help ASAP - Access Module VBA Run Time Error 3141 5 36
2 Global Vars, 1 List Box 4 31
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question