Coverting to 2007

[Gringarlow]

How do I convert Access 2002 versions 2007 versions in Access 2007. I just
upgraded to 2007 and all of the quesries, tables etc are still in 2002
version.

 

[Jerry Whittle]

Unless you need something that is unique to 2007, such as attachment fields,
I recommend just leaving it in the 2002-2003 file format.

 

[Jeff Boyce]

By default, Access 2007 creates/saves in the 2002/2003 version.

If you want to create/save in the 2007 format, try clicking the Office
button, selecting Save As, and picking the appropriate format for saving
your way.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[John W. Vinson]

How do I convert Access 2002 versions 2007 versions in Access 2007. I just
upgraded to 2007 and all of the quesries, tables etc are still in 2002
version.

Do you have some indication that you *need* any conversion? A2007 handles 2002
format databases as is with no conversion needed. There are some "gotchas" -
for instance, if your database has any VBA code you must use the Trust Center
to make its folder a Trusted Location. See Allen Browne's excellent summary at

http://allenbrowne.com/Access2007.html

 

[De Jager]

How do I convert Access 2002 versions 2007 versions in Access 2007. I just
upgraded to 2007 and all of the quesries, tables etc are still in 2002
version.