?
Solved

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

Posted on 2009-04-08
6
Medium Priority
?
996 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
  • 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

864 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