Solved

How to install jpg filters for ART2k using WISE?

Posted on 2004-09-13
24
403 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
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

724 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