Upgraded (?) to Access 2007 - a disaster as far as Access is concerned -
cannot use queries at all. Would like to move back to Access 2003 anyone
know how to do it - our Hosted suppliers do not have a clue!
--
Carol

This is a question for the experts in an Access or Office newsgroup.
Oh, you would uninstall the one you don't want, and install the one you do.
"Carol" <(E-Mail Removed)> wrote in message
news:C1B6812A-DF07-4070-8B3B-(E-Mail Removed)...
: Upgraded (?) to Access 2007 - a disaster as far as Access is concerned -
: cannot use queries at all. Would like to move back to Access 2003 anyone
: know how to do it - our Hosted suppliers do not have a clue!
: --
: Carol

Uninstall the program you don't want to use, install the one you do.

Carol wrote:

> Upgraded (?) to Access 2007 - a disaster as far as Access is concerned -
> cannot use queries at all. Would like to move back to Access 2003 anyone
> know how to do it - our Hosted suppliers do not have a clue!

Carol wrote:
> Upgraded (?) to Access 2007 - a disaster as far as Access is concerned -
> cannot use queries at all. Would like to move back to Access 2003 anyone
> know how to do it - our Hosted suppliers do not have a clue!

Tom and Bob's answers are correct, but why can't you use queries in
Access 2007? They work for me. Type "query" into Access Help.

Bill

Has to do with security, it's greatly increased in new office version, by
default.


"Bill Sharpe" wrote:

> Carol wrote:
> > Upgraded (?) to Access 2007 - a disaster as far as Access is concerned -
> > cannot use queries at all. Would like to move back to Access 2003 anyone
> > know how to do it - our Hosted suppliers do not have a clue!
>
> Tom and Bob's answers are correct, but why can't you use queries in
> Access 2007? They work for me. Type "query" into Access Help.
>
> Bill
>

On 20 Aug 2009, =?Utf-8?B?c2dvcHVz?=
<(E-Mail Removed)> wrote in
microsoft.public.windowsxp.general:

> Has to do with security, it's greatly increased in new office
> version, by default.

This has been true in past upgrades as well. Sometimes Access can
convert your queries, macros and code by wrapping it in compatibility
code (which doesn't always work so well). Other times you have to
rewrite it yourself in order to respect its new security features.
Upgrading Access is not something to be taken lightly, unless you're
only using its most basic features.

sgopus wrote:
> Has to do with security, it's greatly increased in new office version, by
> default.
>
>


That doesn't stop Queries from working, though. Granted, you might
need to change some of the Access 2007 security settings to get macros
to work, but I've never seen Queries be affected, on multiple databases,
some originating as far back as Access 97 and Access 2000.


--

Bruce Chambers

Help us help you:
http://www.catb.org/~esr/faqs/smart-questions.html

http://support.microsoft.com/default.aspx/kb/555375

They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety. ~Benjamin Franklin

Many people would rather die than think; in fact, most do. ~Bertrand Russell

The philosopher has never killed any priests, whereas the priest has
killed a great many philosophers.
~ Denis Diderot