Conversion to Access 2007

[Guest]

Would some of you please post your suggestions for the best resources on
converting from Access 2003 to the new 2007 version? Thanks

 

[Arvin Meyer [MVP]]

http://accessjunkie.com/default.aspx

 

[missinglinq via AccessMonster.com]

The Grand Old Man of Access, Allen Browne, has an entire section devoted to
converting to ACC2007, Including a section called "The Good, The Bad and The
Buggy!" Go to the site and scroll down almost to the bottom of the screen!

http://allenbrowne.com/tips.html

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[Guest]

Thank you both, I wish there were a way to run 2007 with an option to keep it
as a completely separate program rather than one which automatically merges
itself inot any existing configuration.

 

[Douglas J. Steele]

What do you mean by merging itself into an existing configuration?

 

[Guest]

If I load Access 12, will it not load itself as the default application
causing all my 2003 tools to open in the new version? That is what happened
when I loaded the new Excel. I have been hesitating with Access because of
the number of applications I am overseeing with Access 2003.

 

[Arvin Meyer [MVP]]

Both versions will coexist on either an XP or a Vista machine. Load them
into separate folders. I have both complete versions of Office happily
coexisting.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

If I load Access 12, will it not load itself as the default application
causing all my 2003 tools to open in the new version? That is what
happened
when I loaded the new Excel. I have been hesitating with Access because
of
the number of applications I am overseeing with Access 2003.

 

[Douglas J. Steele]

Actually, with Access, the most recently used version will become the
default. (In other words, it changes each time you use a different version)

However, since you're going to have multiple versions, what difference does
it make which is the default? You can always open whichever version of
Access you want to use, and then open the specific application you want.
There are also 3rd party products out there that will detect the version of
Access, and open the application using that version. See, for example,
ACCVER at http://www.aylott.com.au/software.htm or
http://www.openaccess.co.za/BlackAndWhiteInc/AccessOpener.htm

One warning, though. There's currently a major annoyance in that it can take
several minutes to open Access 2007 when it isn't the default version.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

If I load Access 12, will it not load itself as the default application
causing all my 2003 tools to open in the new version? That is what
happened
when I loaded the new Excel. I have been hesitating with Access because
of
the number of applications I am overseeing with Access 2003.

 

[Guest]

Thank you all for your thoughts and advice
--
Jeff C
Live Well .. Be Happy In All You Do

If I load Access 12, will it not load itself as the default application
causing all my 2003 tools to open in the new version? That is what happened
when I loaded the new Excel. I have been hesitating with Access because of
the number of applications I am overseeing with Access 2003.