Navigation Pane Descriptions -2007 Office Service Pack 2

[The Fat Skeleton]

Use MS ACCESS 2007 to manage large volume of accounting data, and have many
tables and queries. I enter a description in these tables and queries to
help me remember what they all do. MS OFFICE Service Pack 2 was released
into my machine last night, and now the descriptions have disappeared in the
navigation pane I use to run queries. Searched for a couple of hours to
recover, but I cannot find the area to recover them. Hopefully someone will
know as I am lost without them. Would appeciate any enlightenment on this.

Thank you,

 

[Maurice]

Have you tried rightclicking the arrows (<<) in the upperright corner of the
nave pane. You should see the option view by... When you choose details you
should see your descriptions again.

hth

 

[The Fat Skeleton]

Maurice, I appreciate the quick response, but I've tried that -- to no avail.
Bear in mind this was working fine until the Office Service Pack 2 was
downloaded to my computer yesterday. Did you get that upgrade, and if so,
are your descriptions still show? Thank you.

 

[The Fat Skeleton]

Yes, that is exactly what I am talking about. I use the view details option
in the navigation pane. I see object name, object type, date created, date
modified, but not the description that used to show. The culprit most likely
is the download of 2007 Office Service Pack 2, which was "pushed" to my PC
last night. Uninstalling this upgrade is not an option. Just would like to
know if anyone knows what can be done so the description field displays as it
did before the upgrade. What I need to know if someone has downloaded the
same upgrade and can still view the description fields when they use the view
details option for the navigation pane.

Thank you,

 

[Maurice]

Well I've been testing this SR2 for quit a long time and did not come across
this issue. As we speak I still have the beta bits installed and still see
the description. My guess would be that in the final shipment of the release
this pointer has become a new issue. I'll post to the guys at MS to see what
has happended with this issue.
--
Maurice Ausum

Well the same thing happened to my db. The Description field goes away when
you apply the SP2 update. I'll check with other MVPs to see what is going on
and post back here.

Yes, that is exactly what I am talking about. I use the view details option
in the navigation pane. I see object name, object type, date created, date
modified, but not the description that used to show. The culprit most likely
is the download of 2007 Office Service Pack 2, which was "pushed" to my PC
last night. Uninstalling this upgrade is not an option. Just would like to
know if anyone knows what can be done so the description field displays as it
did before the upgrade. What I need to know if someone has downloaded the
same upgrade and can still view the description fields when they use the view
details option for the navigation pane.

Thank you,

Are you talking about putting information in the Description box that is
available when you right click on the object and select properties?

[quoted text clipped - 8 lines]

Thank you,

 

[The Fat Skeleton]

To Maurice and Rural Guy, thanks for your responses. This is the first time
I ever posted anything in this forum, and quite honestly, I'm not sure if I
am posting responses correctly. I had no idea there would be this many
replies to my issue, and I do appreciate you taking the time to look into my
problem. I'll keep checking for updates.

Rick

Well I've been testing this SR2 for quit a long time and did not come across
this issue. As we speak I still have the beta bits installed and still see
the description. My guess would be that in the final shipment of the release
this pointer has become a new issue. I'll post to the guys at MS to see what
has happended with this issue.
--
Maurice Ausum

Well the same thing happened to my db. The Description field goes away when
you apply the SP2 update. I'll check with other MVPs to see what is going on
and post back here.

Yes, that is exactly what I am talking about. I use the view details option
in the navigation pane. I see object name, object type, date created, date
modified, but not the description that used to show. The culprit most likely
is the download of 2007 Office Service Pack 2, which was "pushed" to my PC
last night. Uninstalling this upgrade is not an option. Just would like to
know if anyone knows what can be done so the description field displays as it
did before the upgrade. What I need to know if someone has downloaded the
same upgrade and can still view the description fields when they use the view
details option for the navigation pane.

Thank you,

Are you talking about putting information in the Description box that is
available when you right click on the object and select properties?
[quoted text clipped - 8 lines]

Thank you,

 

[The Fat Skeleton]

OK Chris, thanks for your advice. - Rick

Microsoft update service doesn't "push" updates. Your pc sent a request to
download sp2 and installed it. Change this setting so it doesn't happen
again.

In your control panel's automatic updates section, pick *ANY* option besides
"Automatically download recommended updates for my computer and install them.
"

Chris

 

[Maurice]

Hi Rick,

You keep posting that's what we are here for helping each other out. I did
mail the MS guys and the answer I got was to make a support call. Because I
wanted to make sure i asked them what tey meant by that. Does the user have
to send a mail to MS being a registered user so they can support via the
regular channel or what. So i'll keep you posted on that one. Be sure to
mention this to MS eitherway because i will also. When they do hear the
various compliant about these features they might issue a hotfix. Personally
i use the description very much myself for administrative reasons so I can
feel your pain on this one.

--
Maurice Ausum

To Maurice and Rural Guy, thanks for your responses. This is the first time
I ever posted anything in this forum, and quite honestly, I'm not sure if I
am posting responses correctly. I had no idea there would be this many
replies to my issue, and I do appreciate you taking the time to look into my
problem. I'll keep checking for updates.

Rick

Well I've been testing this SR2 for quit a long time and did not come across
this issue. As we speak I still have the beta bits installed and still see
the description. My guess would be that in the final shipment of the release
this pointer has become a new issue. I'll post to the guys at MS to see what
has happended with this issue.
--
Maurice Ausum

Well the same thing happened to my db. The Description field goes away when
you apply the SP2 update. I'll check with other MVPs to see what is going on
and post back here.

The Fat Skeleton wrote:
Yes, that is exactly what I am talking about. I use the view details option
in the navigation pane. I see object name, object type, date created, date
modified, but not the description that used to show. The culprit most likely
is the download of 2007 Office Service Pack 2, which was "pushed" to my PC
last night. Uninstalling this upgrade is not an option. Just would like to
know if anyone knows what can be done so the description field displays as it
did before the upgrade. What I need to know if someone has downloaded the
same upgrade and can still view the description fields when they use the view
details option for the navigation pane.

Thank you,

Are you talking about putting information in the Description box that is
available when you right click on the object and select properties?
[quoted text clipped - 8 lines]

Thank you,

 

[Tony Toews [MVP]]

You keep posting that's what we are here for helping each other out. I did
mail the MS guys and the answer I got was to make a support call. Because I
wanted to make sure i asked them what tey meant by that. Does the user have
to send a mail to MS being a registered user so they can support via the
regular channel or what. So i'll keep you posted on that one. Be sure to
mention this to MS eitherway because i will also. When they do hear the
various compliant about these features they might issue a hotfix. Personally
i use the description very much myself for administrative reasons so I can
feel your pain on this one.

MS are aware this problem as a result The Fat Skeleton's original
posting and ruralguy bringing this to their attention. So I don't
think there's a need to contact them yourself.

Note that it could take a month or two for a hotfix to become
available. Based on my experience in the past.

Tony

 

[Maurice]

Thanks for pointing that out, it's good to hear sounds are getting there. The
reason why I wanted to contact them is because i did a reasonable amount of
testing for the SP2 the last couple of months and this issue never came up.
As I stated earlier the last beta bits i head never showed this problem. So i
was curious where we had to go when we ran into new issues that would arise
based on the final SP2. I got in touch with the betateam about this and for
now this was the answer i was getting. But he i'm glad you guys are on top of
it as well ;-)

 

[deltajsmith]

MS are aware this problem as a result The Fat Skeleton's original
posting and ruralguy bringing this to their attention. So I don't
think there's a need to contact them yourself.

Note that it could take a month or two for a hotfix to become
available.  Based on my experience in the past.  

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages -http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/
Granite Fleet Managerhttp://www.granitefleet.com/

When a fix is availble will it be posted here? I rely on the
descriptions for all my Access objects and am in deep pain in not
having them available.

 

[Tony Toews [MVP]]

When a fix is availble will it be posted here? I rely on the
descriptions for all my Access objects and am in deep pain in not
having them available.

FWIW as soon as I hear of an Access bug fix I post it to my blog. See
my sig below for more details.

Tony

 

[The Fat Skeleton]

Don't know if this will help you or not, but it's been two weeks for me now
since the descriptions disappeared, and I too relied on them heavily, but
I've been able to ease my pain considerably by using a combination of the
grouping options (in navigation options), and using the search option to find
a keyword in the query to ferret out the particular query I want to execute.
Even so, I have to right click on the query to show "properties" sometimes to
make sure I have the right one, as the description still shows there if you
do that. Apparently a lot of ACCESS users do not utilize the description
fields as there haven't been many people like yourself come forward to
describe the problems this causes for the user, but I will be very happy for
the fix to come through so they show again. Hopefully, that will be soon.

Good Luck,

Rick

 

[studioman]

Don't say that. We need to hang in there and make them fix this.
I have been watching this thread hoping for a fix because I have relied
heavily on both viewing and SORTING by the descriptions for years.

I also have a problem with "sputtering" scrolling in the Navigation Pane
since this SP2 introduce bug.
Before SP2, when I would expand a group, there would be a slight delay in
the display of the Descriptions and the detail info would shift down
accordingly.
I think what is happening post-SP2 is this delay is still happening, but
when the 'window' adjusts for the descriptions (that don't actually show), it
appears that the mouse button is sticking on the scroll-bar.
I am curious to know if others are also having this symptom.

FWIW, this is only one of many SP2 problems introduced to my Office 2007.
As a rule, I wait for at least a month before applying an SP, but I was
having so many problems with Office 2007 (my productivity has decreased at
least 25% for the last 4 months since I upgraded from Office 2000), that I
hoped it would be worth immediate implementation.
Oh, well...

 

[The Fat Skeleton]

Yes, I noticed the sputtering scrolling right away, even before I noticed the
descriptions were missing, and I also think it is a result of the description
problem. As far as the mouse button sticking on the scroll bar, I’m not
completely clear on what you are talking about. Anyway, you are RIGHT, they
should fix these problems. It’s just that I spent the last twenty five years
or so figuring out work arounds for problems like this (Other computer
processing problems, not just MS). So my first thought when something goes
wrong is to figure out some stop gap measure that allows us to keep moving
forward as fixes can be slow and unreliable. I’ve spent a career doing that
sort of thing.

You mentioned that you were able to sort on descriptions. Were you able to
sort on them in MS Office 2007, before the SP2 upgrade, of course which wiped
them out completely. I was not able to sort on the descriptions in 2007 as I
was able to before in 2003. Downloading some unauthorized patch for me is
not an option as this is a work machine. So if you have a procedure in 2007,
please let me know.

Thank you,

Rick

 

[racingboy627]

Two of my people are experiencing pain through the SP2 change to Access's
object/table properties. They also have the scrolling/stuttering problem!

I was thinking the very same thing as studioman.

MS - Please help!

-B

 

[glew52]

This is my first attempt at a forum so I hope I'm doing this correctly. I
see it's been a couple of weeks since anyone addressed the problem of the
disappearing descriptions of objects in the nav pane and like you guys, I
rely on them heavily. Anything new from MS on this? Thanks.

 

[Tony Toews [MVP]]

This is my first attempt at a forum so I hope I'm doing this correctly. I
see it's been a couple of weeks since anyone addressed the problem of the
disappearing descriptions of objects in the nav pane and like you guys, I
rely on them heavily. Anything new from MS on this? Thanks.

MS is aware of these two problems, disappearing descriptions and
scrolling/stuttering problems and is working on them. However it
could take at least a month if not two before the fix is available.

Tony

 

[ymann]

I have three new computers that i use for work and they installed MS Access
2007 on them for me. Strange thing, two of them still have the description
showing and one does not - I have compared properties, and anything I can
change and can not get it back on the other computer, but yes, it is still
there of course, but not visible. Let me know what you all find, I also use
this extensively. Hey, I am thinking when we use the search field it only
looks at object names, not anyway to query on the description for when we do
get it back? Help, I can't gripe I at least have two computers I can use
that will still show it, just frustrating. ym

 

[Tony Toews [MVP]]

Does the PC which doesn't display the description have A2007 SP2
installed on it while the others don't?

MS is working on a hotfix for this problem.

Tony