I have been developing in access 2007 Sir but I have these few questions that I have no answers yet and cannot find solution either thru googling.

My questions are:

5. Also, I am thinking if it is possible to change the access accdb icon itself for the current project (not the appIcon setting).

You can't really change the built in access icon. In fact, what happens if a user has other applications written in access? if you change that icon, then all other files icon would also change!

Keep in mind if some software on my computer that changed the access icon, or the Word icon, or ANY icon for all of my applications I would be extremely upset. I would send you a bill for the time and effort to restore this back to the factory icon. So, I must warn you that changing an system icon is a very bad idea. You will get yourself in a heap of trouble with angry users screaming at you as to how you modified their computer. This is my computer and I don't want people like you changing the built in icons.

However, if you want your own application icon to display for your OWN application?

Yes, you can most certainly do this.

What you do is use a shortcut placed in the menu bar, and even a shortcut on your desktop. For this shortcut you can have a custom icon. It is most certainly recommend you do this for your custom applications.

I have a sample access application here with an install that will display a DIFFERENT icon then the access one. And, the shortcut that is placed on your desktop is also different.

This sample will thus:

a) Display the custom icon on your desktop that when clicked will launch the application (so, a shortcut is placed on your desktop).

b) In the start menu->programs menu, you will again see this application name, and again you see the custom icon, not the access one.

c) When you launch the application, in the task bar, you will again you see the custom icon, not the access one.

Here is a link to this sample:
http://www.members.shaw.ca/AlbertKallal/Ru...tallExample.htm

If you are considering to use the access runtime, the above is part of an article that you should read here:
http://www.members.shaw.ca/AlbertKallal/RunTime/Index.html

So, for most intents here, the above should give you most of what you want, and thus you can display a different icon in place of the access icon. However, you don't want to replace the built-in access one, since people might have other access applications on their computer and changing that icon would not be respectful of the users computers.

Note that the above article is for the access runtime, but you can well and easy test/try that sample install on your computer with the full version of access 2007 installed.

Also note that when you launch this application, notice how all of the built in access application is hidden, and thus the office button, QAT, and even the nav pane is all hidden. This "hiding" is accomplished by using the built-in access startup options (please take a look at the sample in the above link, you are free to open up that sample and view the access settings I used).

Albert D. Kallal
Edmonton, Alberta Canada
kallal@msn.com

yes, I know Sir that it would affect all access application but what I was thinking for the current project only if that was possible.

but I guess there is no way there. I am going to see your link sir and test it at home. thanks.