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!!
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!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<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
<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
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.
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.
ASKER
Thanks everyone!!
For that matter, sharing even within the same version of Access is a Very Bad Idea.
:)