Decompile switch

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I couldn't find a better topic to bring this up, hope this is the right place

I have Access 97 and 2003 installed and over the years have often used the /decompile switch with Access 97. When I run msaccess.exe /decompile from the run command, Access 97 runs (regardless of which version I last used), and allows me to decompile a database

However, when I try to do the same with Access 2003 (by typing in the full path to the Access 2003 version of msaccess.exe) and use the /decompile switch, Access 2003 starts up, but does not ask for a file like 97 does, to decompile

I'm hoping there's a way to get this to work, as we make changes so often, I find it helpful to create a new file, import in all the objects, run decompile, and start fresh

Any advice would be greatly appreciated

Thanks
 
Hi, Tom


From your description, I understand that you would like to have decompile
switch effective in Access 2003. If there is anything I misunderstood,
please feel free to let me know.

In Access 97, you could make it by: "C:\Program Files\Microsoft Office
98\OFFICE\MSACCESS.EXE" /decompile "C:\yourDB.mdb"
while in Access 2003, you'd better make it by "C:\Program Files\Microsoft
Office 2003\OFFICE11\MSACCESS.EXE" "C:\youDB.mdb" /decompile

you will not get any notification in Access 2003, however, if you turned to
Complie menu, you will find it is enable again, which shows that you have
successfully decompiled it. What's more, you cannot just decompile it
without running it.

Hope this helps. Please feel free to post in the group if this solves your
problem or if you would like further assistance.

Thanks

Sincerely yours,

Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
 
Michael

Thanks for your reply. I did get it to work, the difference, which threw me, in Access 97 was that when it is run with the /decompile switch and no db name, a dialog opened prompting to choose a database, in 2003, it seems the db name is necessary, and as you say, there is no message indicating the decompile has occurred

BTW, on another topic, I often use icons as the picture on a command button, or make my own buttons with icons. I was hoping, but it doesn't appear to be the case, that Access 2003 would support XP icons. Is there any way to use these, or a workaround

Thanks again

Tom
 
Hi, Tom

Thanks for your reply.

First of all, when launching Access 2003 with "msaccess /decompile" you
will not see an opened dialog prompting choosing, however, you will found
that your first database opened is decompiled.

Secondly, I really have no idea about what XP icon is. In my opinion, you
could find Format label in Command Button properties, and then you will
find an attribute name Picture. You could add pictures in this way.

Hope this help and please fell free to post if there is anything more I can
do to assist you.



Sincerely yours,

Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
 
Hi, Tom

I wonder have you successfully use icons as picture on your command button?

Assuming that your XP icon means Windows XP icons.
1. right click command button -> choose Properties
2. in Properties, select All page and you will find Picture attribute
3. click ... , which is on the right side of the blank
4. you can choose icon or bmp files you like :)



Hope this help and please fell free to post if there is anything more I can
do to assist you.



Sincerely yours,

Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
 
Michael

Thanks for your assistance. I've been using the technique you mentioned for years, however as far as I can see, MS Access does not support inserting an XP type icon as a picture. I've had to change the icon's resolution to a non-XP version, e.g. 32X32 true color, then it works

I was curious as to why the XP icon format is not supported, considering Access 2003 is so new..

Thanks again

Tom
 
Hi, Tom

It seems that inserting XP icon needs some time to make research on it,
However, it has little realtionship with the original one "Decompile
switch". In order to further troubleshooting the problems, I guess, would
you please post a new one to describe it?

Thank you for your patience and cooperation. If you have any further
question or concern about decompile switch , don't hesitate to let me know.
We are here to be of assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
 
Hi Tom,

How do you get those XP icons? Do you extract them by some third party
tools? If not, would you please tell me an example of one?

I use a third party tools to extract some icons from XP system, and found
it will be an error when I try to use "XP icon", which seems to be in a
format of 48*48*32bit, but after a deeply code tracing, It turned out to
not be the Access but the ICON file itself that makes errors.

Those "XP icon's" extracted by third party tools are not in standard ICON
format, so Access will refuse to import them. You can try to repair them by
opening the icon file with Microsoft Visual Studio and then SAVE it.

In this way (I opened icon file with VS.Net), I found it was able to be
used in Access as a Command Button Picture.

Thank you for your patience and cooperation. If you have any questions or
concerns, please don't hesitate to let me know. We are here to be of
assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
 
Back
Top