Unable to view Property Details on a Query

[Jenn]

Service Pack 2 was loaded onto our computer systems and it has taken away the
visibility of the property details on a query. Would anybody know about
viewing them without having to right click and actually going into the object
properties? We want them to show under the Date Created and Date Modified
under the Navigation pane. It is not an Option for us to remove Service Pack
2.

 

[Tom Wickerath]

Hi Jenn,

If you right-click on the "All Access Objects" label, and then select View
By > Details, I think you will see the missing properties again.

Note: It is always best to include the version of Access that you are using.
I surmised the version as Access 2007, from your reference to the Navigation
pain, but it's always best to avoid any ambiguity.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Jenn]

Thanks Tom for your response. Yes it is Access 2007 that I am using and we
are running Window's XP Professional. We tried your suggestion and that does
not work. We are thinking it has something to do with Windows Service Pack 2
that was loaded on to our PC's. We tried taking the Window's Service Pack off
of one computer, and when we did that it showed the Object Properties. Due
to the security that the Service pack has, we have to load it back onto the
computers, and it is not an option to take it off.

Do you know of anything else we can try?

 

[Tom Wickerath]

Hi Jenn,

I do not have an XP machine at the present time with Office 2007 installed
on it--my current XP machines--both home and work--have Office 2003
installed. I'll try to remember to ask a co-worker at work tomorrow who is
running XP SP-2 with Office 2007.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Jenn]

Tom,

Thank you so much! Let me know if you find out anything. Our IT department
hasn't been able to figure this one out. So any help is truly appreciated.

Jenn

 

[Tom Wickerath]

Hi Jenn,

I think I found the answer....try installing hotfix 973405 after installing
SP-2. I probably did this a while back, but had forgotten about it.

http://support.microsoft.com/kb/973405

Issues that this hotfix package fixes includes the following:

After you apply 2007 Office system Service Pack 2, the description of an
object does not appear in the Navigation Pane in Access 2007. This problem
occurs when the Navigation Pane is viewed by Details.



Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Tom Wickerath]

PS. I forgot to mention that you might want to have a look at Access MVP
Allen Browne's page here:

Converting to Access 2007
http://allenbrowne.com/Access2007.html

He includes a section near the top titled "Updates/Hotfixes", which is
actually where I went looking this morning for the issue you described. There
may be other hotfixes that you'll be interested in as well.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Jenn]

Tom,

Thanks again for your assistance we will see if our IT department will
install the hotfix and go from there.

Jenn

 

[Jenn]

Tom,

Thank you so much for your assistance with this issue. The hotfix
definitely fixed the problem we were having.

Have a wonderful day!

Jen

 

[Tom Wickerath]

Hi Jenn,

Thank You for the confirmation. Glad to read that you got it working!
Don't forget to get some of those other important hotfixes as well.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________