EthanL
asked on
Converted Accdb to MDB but Images not showing on different computer.
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)
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)
ASKER
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"
:-(
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"
:-(
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
u may need to register it to a app that can open that bmp
ASKER
It shows BMP is registered to Paint software.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Good work there. Glad you got it sorted.
ASKER
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.