Avatar of JB4375
JB4375
Flag for United States of America asked on

Unable to View Access 2003 Database Queries in Access 2007

I got a call today from a person that designed an Access 2003 database. She's created and is able to view all the queries associated with it.

She has a coworker that is running Access 2007 on her computer. She has rights to the share where the database is located, and is able to get it with no problems. However she is not able to see any of the associated queries. The creator even provided her with a shortcut to one of the queries but she still can't view them.

I know nothing about Access but it seems that it's a problem resulting from the different versions. However, Microsoft is usually pretty good about backwards compatability. Any ideas?

Thanks in advance!!
Microsoft ApplicationsMicrosoft OfficeMicrosoft Access

Avatar of undefined
Last Comment
JB4375

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
als315

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
peter57r

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Patrick Matthews

>>Sharing a file between different versions of Access is a recipe for corruption.

For that matter, sharing even within the same version of Access is a Very Bad Idea.

:)
Jeffrey Coachman

<she is not able to see any of the associated queries>
<provided her with a shortcut to one of the queries but she still can't view them.>

JB4375, just so we are clear...
When you say: "not able to see" and "can't view them"
Do you mean that they cant "Run" the query and "See" the results...?
Or are you saying that they don't even see the query(s) listed...?

   "A picture is worth a thousand words"

Please post a screenshot of where this works, and where it does not.

Thanks

JeffCoachman
Anastasia D. Gavanas

Boag is right...
if you simply cant see them, you need to load the queries from the select object pane on the left.
if you can't run them, that is a different story.
Anyhow, creating a local copy of the file is a good idea to see why the file can not be used properly.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
JB4375

ASKER
Thanks everyone!!