Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 423
  • Last Modified:

How to install jpg filters for ART2k using WISE?

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
jaimexctsg
Asked:
jaimexctsg
  • 12
  • 10
1 Solution
 
shanesuebsahakarnCommented:
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
 
jaimexctsgAuthor Commented:
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
 
jaimexctsgAuthor Commented:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
shanesuebsahakarnCommented:
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
 
shanesuebsahakarnCommented:
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
 
jaimexctsgAuthor Commented:
The update runs after section 6 of the Sagekey script.
0
 
jaimexctsgAuthor Commented:
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
 
jaimexctsgAuthor Commented:
OK I am going to try that. So i go to the Sagekey site or the WISE site?
0
 
shanesuebsahakarnCommented:
I would check to see if SageKey has a complete (and fully patched) A2K runtime for download.
0
 
shanesuebsahakarnCommented:
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
 
jaimexctsgAuthor Commented:
Ok i'll check it outThanks, Will get basck aa soon as I try it.
0
 
jaimexctsgAuthor Commented:
This doesnt look good. It still tells me that my MDB cannot handle jpg's.  
0
 
shanesuebsahakarnCommented:
Hmm. Can it handle GIFs and BMPs?

Did you find the file I was referring to on the SageKey site?
0
 
jaimexctsgAuthor Commented:
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
 
shanesuebsahakarnCommented:
OK, let me know how you get on.
0
 
jaimexctsgAuthor Commented:
Ok. Out to lunch for a litlle bit
0
 
jaimexctsgAuthor Commented:
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
 
shanesuebsahakarnCommented:
I will try to take a look for you when I get hold of our copy of SageKey.
0
 
jaimexctsgAuthor Commented:
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
 
jaimexctsgAuthor Commented:
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
 
shanesuebsahakarnCommented:
Ah ok, it looks like the A2K2 version of the runtime does include those files (or Sagekey included them for us).
0
 
shanesuebsahakarnCommented:
No objections.
0
 
ee_ai_constructCommented:
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 12
  • 10
Tackle projects and never again get stuck behind a technical roadblock.
Join Now