Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / June 2005

Tip: Looking for answers? Try searching our database.

Compatibility 2002-2002-2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Candyman - 28 Jun 2005 21:27 GMT
I am creating a Db in Access 2000. Our office is upgrading to 2003. My
counterpart in another state has 2002. Will I have a problem converting to
2003 or should we convert to 2002 using her program and my Access 2003 will
handle be backward compatible to 2002 version?  Any programming will be done
on my machine (2003).
Joan Wild - 28 Jun 2005 21:42 GMT
>I am creating a Db in Access 2000. Our office is upgrading to 2003. My
> counterpart in another state has 2002. Will I have a problem converting to
[quoted text clipped - 3 lines]
> done
> on my machine (2003).

All those versions use the 2000 format by default.  You don't need to
convert as each can read the 2000 format.  You would just have to be sure
not to use features in a newer version that don't exist in prior versions.

Signature

Joan Wild
Microsoft Access MVP

Larry  Linson - 28 Jun 2005 23:14 GMT
Access 2002 and 2003 use the same file format. There should be no
compatibility problems even if you have set the option to "Save in Access
2002 Format" and "Save in Access 2003 Format". I specifically say "set the
option" because the default for both is that they save in Access 2000 file
format. This is for MDB files.

In my experience MDE files are still version-specific as follows: an MDE
created with Access 2003 will not run under Access 2002, but Access 2002
MDEs have run successfully under Access 2003. (But I am not certain that
_all_ Access 2002 MDEs will run under Access 2003.)

When you save in Access 2000 format, you give up any new features that were
introduced in the later versions. One that I have found particularly useful
is OpenArgs for passing information to a Report opened with the
DoCmd.OpenReport statement. Colleagues who do more data analysis
applications are find Pivot Tables and Pivot Charts useful. If you are
content with the features now available when you develop in Access 2000,
that would be a valid option for you, though, as I pointed out in the first
paragraph, you should have no difficulty with MDB files made in Access 2003
running in Access 2002 and vice-versa, and MDEs made with 2002 may well run
under 2003.

 Larry Linson
 Microsoft Access MVP

> I am creating a Db in Access 2000. Our office is upgrading to 2003. My
> counterpart in another state has 2002. Will I have a problem converting to
> 2003 or should we convert to 2002 using her program and my Access 2003 will
> handle be backward compatible to 2002 version?  Any programming will be done
> on my machine (2003).
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.