Solved

How to install jpg filters for ART2k using WISE?

Posted on 2004-09-13
24
397 Views
Last Modified: 2008-01-09
The Access2000.mde works percfectly on a PC that has Office installed.
Then it was compiled for installation using Sagekey for WISE, and the

Setup.exe was created. This installs both the Access 2000 RT, and the mde,

to the target PC, along with the database icon.
When installed in a PC that has  MS Office 2000 installed, everything

compiles and works OK. But when installed in a PC without MS Office 2000,

the images don't show up.
It uses unbound image frames that get their "x:\directory\myimage.jpg"  

from a textbox, that has a text field in the underlying table. This textbox

has a lookup routine to the directoriesin the PC, and the text does show.
I gather the filters for jpg need to be included in the installation. I dont

have the faintest idea of how to code this. or which files to include, and

how to register these files so they waork with the Access 2000 RT.
I have thought of creating a separate executable for this tas and running it

as part of the installation routine.
I have searched the internet but cannot figure out how to incorporate some

of the solutions there. (For example "A2KLoadJpegGifVer33GDiPlus" would

not do since I would have to reprogram too many forms.) This is just a wild

guess, but I would need to do something similar to installing some type of

picture viewer that would allow the jpg to function in Access.
What are the filters handle jpg as images?
How can I make sure they register correctly?
0
Comment
Question by:jaimexctsg
[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
  • 12
  • 10
24 Comments
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12048642
Hmm - when we built a run-time using Wise/Sagekey, we didn't have the same problem. Did you download the runtime files from Sagekey, or did you create the set yourself usng the Office Developer's Kit? Your help file should give you a link to download the appropriate build from their website.
0
 

Author Comment

by:jaimexctsg
ID: 12049237
i used the Sagekey script. The one that comes for a front end and a backend. I changed the names of the files and some compiler varables and I compiled and ran ok in the development PC.
One thing to note is that the test PC only has the OS (W2k) and the drivers. Also downloaded thge SP3 upgrade for Access RT from Sagekey.
0
 

Author Comment

by:jaimexctsg
ID: 12049247
Oh sorry, about the runtime, I used the runtime from the Developer CD and then ran the update, Is that how you did it?
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12049252
OK, I haven't built a A2K runtime, only an A2K2 runtime, and you can download a full service-packed file set from them, which I think includes the filters. I don't know if the equivalent exists for A2K.
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12049262
Sorry no, I didn't use the RT from the Dev CD - I downloaded a pre-made one for use with the scripts from Sagekey themselves.
0
 

Author Comment

by:jaimexctsg
ID: 12049266
The update runs after section 6 of the Sagekey script.
0
 

Author Comment

by:jaimexctsg
ID: 12049312
When installed the Access RT version is "9.0.3822". I got this by going to C:\Program Files\Microsoft Office\ART\Office\MSACCESSS.EXE right click and then going to properties, Version Tab, Item Name Product Version.
0
 

Author Comment

by:jaimexctsg
ID: 12049315
OK I am going to try that. So i go to the Sagekey site or the WISE site?
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12049318
I would check to see if SageKey has a complete (and fully patched) A2K runtime for download.
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12049323
Sorry, it's on the SageKey, but the correct URL is somewhere in the SageKey help file, IIRC. I don't have it installed on this machine so I can't check.
0
 

Author Comment

by:jaimexctsg
ID: 12049354
Ok i'll check it outThanks, Will get basck aa soon as I try it.
0
 

Author Comment

by:jaimexctsg
ID: 12050480
This doesnt look good. It still tells me that my MDB cannot handle jpg's.  
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12050490
Hmm. Can it handle GIFs and BMPs?

Did you find the file I was referring to on the SageKey site?
0
 

Author Comment

by:jaimexctsg
ID: 12050740
Yes, I downloaded the file "Sr3Update.zip". And added it. I am starting from scratch again, using the Demo for sterters. Probably will be here all night, the images are the selling point of this mdb. The customer, a small business owner, will be able to save  pictures of the steps taken to fix something, then he uses this progress for billing his clients.
One idea I will probabluy try, is to import all my db objects into the Demo, then compile from the basic instructions. Then see if when setup runs on the target PC it works. But any ideas are appreciated, and will be rewarded.
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12050761
OK, let me know how you get on.
0
 

Author Comment

by:jaimexctsg
ID: 12050917
Ok. Out to lunch for a litlle bit
0
 

Author Comment

by:jaimexctsg
ID: 12060089
No, it didn't work. Let me ask it another way. Can anyone tell me exactly where in the Sagekey for WISE script are the instructions for loading the graphic filters to the target PC. I have the latest version ov Sagekey, please tell me the script, and the line number or numbers where the code for this is stored.
There are some sample scripte also, I have all of them and cannot find this information. A right answer wiil get 500 points. Thanks!
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12060100
I will try to take a look for you when I get hold of our copy of SageKey.
0
 

Author Comment

by:jaimexctsg
ID: 12060144
I added a similar question for 500 points. This is a very difficult and urgent question so the first correct answer will get all the points.
0
 

Author Comment

by:jaimexctsg
ID: 12061524
I found the answer! Here it is for all to see.

In order for Access runtime to be able to work with jpg files, it needs some converters and filters which are not included when the runtime version of Access, is installed in a computer that does not have Office already installed.  Microsoft released an "Office File Converter Pack" called OCONVPCK.EXE  that can be downloaded from:
"http://www.microsoft.com/downloads/details.aspx?FamilyID=cf196df0-70e5-4595-8a98-370278f40c57&DisplayLang=en"
Just run this executable and it automatically installs and registers the support files needed.
You must install the Access runtime first in the target computer, then run this this file to install the necessary converters and filters. This will allow your runtime version of Access to access jpg files, as well as other files. Read the details at:
"http://office.microsoft.com/en-us/officeupdate/CD010225801033.aspx"
A word of caution, if Access RT is not installed first, the fiile "OCONVPCK.EXE" will not install or register the needed converters and filters.
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12063494
Ah ok, it looks like the A2K2 version of the runtime does include those files (or Sagekey included them for us).
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12085773
No objections.
0
 

Accepted Solution

by:
ee_ai_construct earned 0 total points
ID: 12112006
Please read entire thread.  Asker solved or content important.
Closed, 300 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Admin
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Many to Many From without subform 11 77
MS ACCESS VBA FORMATTING 9 57
Cant delete records in query 8 40
Combo box with two columns question 7 28
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
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…

740 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