Solved

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

Posted on 2009-04-08
6
984 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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
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 how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

746 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now