Deliver Access startup application icon via the MDB?

  • Thread starter Thread starter Kipp Woodard
  • Start date Start date
K

Kipp Woodard

Has anyone worked out how to store an icon in an MDB, save it to disk via VBA
code, and then set the Application icon property?
 
Kipp Woodard said:
Has anyone worked out how to store an icon in an MDB, save it to disk via
VBA
code, and then set the Application icon property?
Click to expand...

You are 100% correct in assuming that the icon you specified does not go
with the application when you move it to another machine. So I'm very well
understand the reason for asking your question.

I think in this case would I would do is actually build an install script
for the user. That way you also have a consistent location as to where you
install the database (application).

I have a sample install script that shows you how to copy the mdb file +
icon to a given direcity location in the following article of mine. It's
written for 2007, but it can be reused for any version of access.

I think the instant you start having additional files like that icon, then
for these related things that are outside of the database, then I think
that's the point in time in which you should adopt using the SAME directory
location for everybody, and some type of installer.

Here is that article:
http://www.members.shaw.ca/AlbertKallal//RunTime/Index.html
and the script part is here:
http://www.members.shaw.ca/AlbertKallal//RunTime/InstallExample.htm

In the above, my icon is merge.bmp

I also think that for distributing your applications and copying them
around, you should likely deploy as a mde, not a mdb. (however this approach
thus assumes that you split your database).
 
Thanks Albert.

Creating an install is no problem, but what I really want to do is to store
my icon in a table, and deliver it that way.

Thanks for including the links. Very useful.

Kipp Woodard (former Access MVP)
 
david said:
Have a look here:

http://www.lebans.com/

Steven Lebans isn't answering questions right now, but if there
is anything, that is where it will be.
Click to expand...

Correct.

Have a look here: http://www.lebans.com/oletodisk.htm
NEW - Apr. 14/2002 A2KExportOLEtoJPEG.zip A2K ONLY! This
version saves the entire contents of a table containing OLE Object
Images to disk based Jpeg files. User selectable compression rate.
Version 1.5

Use the A2KExportOLEtoJpeg above instead of these following older
versions!

SaveOLEtoBitmap.zip is a database containing functions to allow you to
save the contents of an OLE Field to a disk based Bitmap file.

SaveOLEtoBitmapAuto.zip is a database containing functions to allow
you to save the contents of an OLE Field to a disk based Bitmap file
for the entire table automatically.

Tony
 
Back
Top