Solved

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

Posted on 2009-04-08
6
988 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

763 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