Error 2114 problem
Posted on 2011-02-27
I have a realy strange thing that has happened and cannot find anything to resolve the issue despite a wide search on the net.
A database that I made for a friend to catalogue his memorabilia included a control to add images for his items. On his machine if he adds a image that is a jpeg it throws up the 2114 error
On my machine it loads the image with no problem.
The difference is that my machine is running windows 7 32bit with office xp sp3 loaded
His machine is running Windows 7 64bit with office xp sp3 loaded.
In my search I have found out that microsoft have no intention of developing a service pack 3 for windows 7 operating in a 64bit environment but understand that it may be an issue to do with filters and sp3.
As a test I created a form on the database on my machine and inserted a image control on the form. When the system image search form comes up, the drop down file type includes "JPEG File Interchange Format" amongst a whole lot of others that are absent on the 64bit computer.
I know that this is going to throw a lot of suggestions up about changing the computer operating 64 bit to a 32 bit or to buy a 3rd party piece of software that doesn't have the issue or upgrading the office/access to 2007 or 2010 but i'd like to make it clear that this isn't an option nor is changing the jpegs to bitmaps as there are to many images to convert.
Has any one come across this problem or have a suggestion of how I can get this sorted?
with grateful thanks in advance