Access 2007 >> 2003 Classic look?

[Dave]

I have just started using Access 2007. I work for an international company
that uses SAP, SQL, Brunette & Oracle as it's server databases. As a
developer I have relied on Access to bring the data together in a usable
format for distribution.

After opening 2007 my productivity is brought to a halt as I struggle to
find things in the new interfcae.

Is there the ability in Access 2007 to switch to a Classic view as XP has
with it's user interface?

Are there cheat sheets somewhere that says here is a mp to get there?

Are there plug ins that will give a 2003 interface as I get past the
learning curve?

Any guidance would be appreciated.

Thanks
Dave

 

[Dave]

Your links are great, thanks!!!

In the Detailed look for Tables, Queries, etc in 2003 it listed several
attributes including the description in columns for the Objects.

The description is a big part for me, I have selected Details in 2007, but
it does not list in columns and the description is not show in the detail
look.

Is there a way to do both?

Thanks again.

Dave

 

[Dave]

Thanks for the answer - I was afraid of that.

Is there a way to doucmnet Objects in Access other than the Description
field, something new as a replacment?

I am afraid of your answer

Dave

 

[Jeff Conrad [MSFT]]

in message:

The object description was removed from the nav pane in Access 2007 sp2.

A slight modification to your statement there Chris because it could be
misinterpreted.

The object description was not removed from the Navigation Pane in SP2 on
purpose, it was a regression in the product.

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[Jeff Conrad [MSFT]]

in message:

Hi Chris,

I know it wasn't on purpose, but IT'S GONE! (I know the marketers have a gun
to your head to make you say "it's a regression".)

There are no marketers around me Chris, nor does anyone have a gun to my head. Your comment is
completely unwarranted and totally unprofessional.

Exactly which version of Access did 2007 sp2 regress to? I don't remember any version without a
description column in the database window or navigation pane.

I think you're completely misunderstanding the issue I'm talking about here. In Access 2007 RTM and
Access 2007 SP1 if you applied a custom Description to an object, that description would show in the
Navigation Pane if you selected the view called Details.

In Access 2007 SP2, there is a regression that the Description no longer shows up when you select
the Details view. The property is still attached to the object, but it's just not showing in the
Navigation Pane now. That's the regression I'm talking about. It was not intentional, it was a
regression from other changes.

P.S. Doesn't your book's cd have a replacement database window for Access
2007 dbs, including a description column?

Nothing on the CD for a replacement database window; we ran out of time. I think you might be
thinking of the utility I have posted here:

http://accessjunkie.com/faq_13.aspx

The one John and I made does not display the Description property, however, some of the other
utilities I list on that page I think do include the Description property.

Keep in mind you can also still get this information by running the Documenter or some of the
utilities I have listed here:

http://www.accessmvp.com/JConrad/accessjunkie/doctable.html

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com