A2003 About Microsoft Access and SP3?

[Salad]

I have Microsoft Office Professional 2003 and the computer I connect to
also has A2003 retail. The others in that office use Access 2003 runtime.

Q1) I wanted to see if they were up-to-date on their service pack but
the "About Microsoft Office" menu item is missing when the run my app.
Is there a way to view the About form in the runtime version from the menu?

Q2) Also, do folks with a runtime version need the SP3 and hotfix?

Q3) Is there a way from Help/About MS Access to determine if the hotfix
was applied?

I initially got the HotFix for my computer because the first table in
for an append query wouldn't display in the dropdown. Allen Browne
noted that this is a SP3 problem that MS didn't correct in the HotFix.

[Tony Toews [MVP]]

Re: A2003 About Microsoft Access and SP3?

Salad <oil@vinegar.co mwrote:

>I have Microsoft Office Professional 2003 and the computer I connect to
>also has A2003 retail. The others in that office use Access 2003 runtime.
>
>Q1) I wanted to see if they were up-to-date on their service pack but
>the "About Microsoft Office" menu item is missing when the run my app.
>Is there a way to view the About form in the runtime version from the menu?

No, because the runtime doesn't have a menu. You have to do it yourself.

>Q2) Also, do folks with a runtime version need the SP3 and hotfix?

Yes, because the runtime is created using the files as distributed with the runtime.
So they're woefully out of date.

>Q3) Is there a way from Help/About MS Access to determine if the hotfix
>was applied?

I think the version of msaccess.exe is updated.

What I've done is use the various API calls available and am checking the version
number and date/time of a crucial dll, msjetxx.dll, to ensure it matches what I have
on my system. See the Verify Appropriate Jet Service Pack is installed page at my
website for more details including sample code:
www.granite.ab.ca\access\verifyjetsp.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at

http://www.granite.ab.ca/accsmstr.htm

Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[Salad]

Re: A2003 About Microsoft Access and SP3?

Tony Toews [MVP] wrote:

Salad <oil@vinegar.co mwrote:
>
>

>>I have Microsoft Office Professional 2003 and the computer I connect to
>>also has A2003 retail. The others in that office use Access 2003 runtime.
>>
>>Q1) I wanted to see if they were up-to-date on their service pack but
>>the "About Microsoft Office" menu item is missing when the run my app.
>>Is there a way to view the About form in the runtime version from the menu?

>
>
No, because the runtime doesn't have a menu. You have to do it yourself.
>
>

>>Q2) Also, do folks with a runtime version need the SP3 and hotfix?

>
>
Yes, because the runtime is created using the files as distributed with the runtime.
So they're woefully out of date.
>
>

>>Q3) Is there a way from Help/About MS Access to determine if the hotfix
>>was applied?

>
>
I think the version of msaccess.exe is updated.
>
What I've done is use the various API calls available and am checking the version
number and date/time of a crucial dll, msjetxx.dll, to ensure it matches what I have
on my system. See the Verify Appropriate Jet Service Pack is installed page at my
website for more details including sample code:
www.granite.ab.ca\access\verifyjetsp.htm
>
Tony

[Salad]

Re: A2003 About Microsoft Access and SP3?

Tony Toews [MVP] wrote:

Salad <oil@vinegar.co mwrote:
>
>

>>I have Microsoft Office Professional 2003 and the computer I connect to
>>also has A2003 retail. The others in that office use Access 2003 runtime.
>>
>>Q1) I wanted to see if they were up-to-date on their service pack but
>>the "About Microsoft Office" menu item is missing when the run my app.
>>Is there a way to view the About form in the runtime version from the menu?

>
No, because the runtime doesn't have a menu. You have to do it yourself.

Yes, I created a menu. I dragged the menu pad About to the new menu
from the database menu but the About option is removed/hidden when
opened with the /runtime feature. Since that doesn't work I guess I
have to call
docmd.RunComman d acCmdAboutMicro softAccess
to view the form from the menu.

>>Q2) Also, do folks with a runtime version need the SP3 and hotfix?

>
Yes, because the runtime is created using the files as distributed with the runtime.
So they're woefully out of date.

Once I get the menu item About fixed I'll check on the folks and see
what they've got.

>>Q3) Is there a way from Help/About MS Access to determine if the hotfix
>>was applied?

I think the version of msaccess.exe is updated.
>
What I've done is use the various API calls available and am checking the version
number and date/time of a crucial dll, msjetxx.dll, to ensure it matches what I have
on my system. See the Verify Appropriate Jet Service Pack is installed page at my
website for more details including sample code:
www.granite.ab.ca\access\verifyjetsp.htm

I will do so. Thanks.

>
Tony