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 / New Users / March 2005

Tip: Looking for answers? Try searching our database.

Converting DB

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
j - 31 Mar 2005 18:41 GMT
I have a database in the '97 format. Is there a way I can run it or convert
it so that it will be compatible with 2000, 2002, and 2003?

Please help!

Thanks!
j
John Vinson - 31 Mar 2005 20:04 GMT
>I have a database in the '97 format. Is there a way I can run it or convert
>it so that it will be compatible with 2000, 2002, and 2003?

Open it in any of these three programs, and accept Access' offer to
convert it to Access 2000 format. All three of 2000, 2002 and 2003 use
2000 format as the default.

The A97 database will already be usable by any of the later versions,
but you won't be able to make any form, report or other design changes
without converting it.

                 John W. Vinson[MVP]    
Timothy Raines - 31 Mar 2005 20:09 GMT
You can easily convert a basic database from Access 97 to Access 2003. You
must first have the new version of Access. Then you must open the Access 97
database from the new version. It will prompt you to convert it. My
suggestion is to change the name of the Access file that you are creating
instead of overwriting the previous Access 97 file. That way you can
compare behavior.

If the Access 97 database is more complicated (it has modules, forms, and
macros), then a bit more work may be involved. You will have to change the
Data access method from DAO 2.5 to DAO 3.6.
Tim
 
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.