By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,376 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

A2003 About Microsoft Access and SP3?

P: n/a
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.
Oct 29 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Salad <oi*@vinegar.comwrote:
>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/
Oct 30 '08 #2

P: n/a
Tony Toews [MVP] wrote:
Salad <oi*@vinegar.comwrote:

>>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
Oct 30 '08 #3

P: n/a
Tony Toews [MVP] wrote:
Salad <oi*@vinegar.comwrote:

>>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.RunCommand acCmdAboutMicrosoftAccess
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
Oct 30 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.