Solved

How to install jpg filters for ART2k using WISE?

Posted on 2004-09-13
24
345 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
  • 12
  • 10
24 Comments
 
LVL 41

Expert Comment

by:shanesuebsahakarn
Comment Utility
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
Comment Utility
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
Comment Utility
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
 
LVL 41

Expert Comment

by:shanesuebsahakarn
Comment Utility
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
Comment Utility
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
Comment Utility
The update runs after section 6 of the Sagekey script.
0
 

Author Comment

by:jaimexctsg
Comment Utility
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
Comment Utility
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
Comment Utility
I would check to see if SageKey has a complete (and fully patched) A2K runtime for download.
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
Comment Utility
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
Comment Utility
Ok i'll check it outThanks, Will get basck aa soon as I try it.
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 

Author Comment

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

Expert Comment

by:shanesuebsahakarn
Comment Utility
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
Comment Utility
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
Comment Utility
OK, let me know how you get on.
0
 

Author Comment

by:jaimexctsg
Comment Utility
Ok. Out to lunch for a litlle bit
0
 

Author Comment

by:jaimexctsg
Comment Utility
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
Comment Utility
I will try to take a look for you when I get hold of our copy of SageKey.
0
 

Author Comment

by:jaimexctsg
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
No objections.
0
 

Accepted Solution

by:
ee_ai_construct earned 0 total points
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
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…

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now