Access back to Access 2003

  • Thread starter Thread starter Carol
  • Start date Start date
C

Carol

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!
 
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.
: 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
 
Carol said:
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!
Click to expand...

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.
Click to expand...

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 said:
Has to do with security, it's greatly increased in new office version, by
default.
Click to expand...


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://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
 
Back
Top