Solved

convert an MSaccess 97 database stright to A2007

Posted on 2016-08-17
2
38 Views
Last Modified: 2016-08-17
Hi all,

would anyone know the precise way of converting an MSAccess 97 database straight through to A2007

Thanks
0
Comment
Question by:PipMic
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 41759117
Have you tried simply opening the database (a copy) with 2007, then saving it as an ACCDB?

I've got to admit, I don't think I've seen a db created in '97 in many years.

There were a number of changes between '97 and '03, but the biggest was probably the addition of ADO.  You will need to make sure you explicitly type all of your recordset objects as DAO.Recordset if you want it to function as it does now.  May have to add the Data Access Objects reference to the project as well.

Dale
0
 
LVL 30

Accepted Solution

by:
Scott C earned 500 total points
ID: 41759119
Convert an Access 97 database

When you open an Access 97 database in Office Access 2007, the Database Enhancement dialog box appears. To convert the database to the Access 2007 file format, click Yes. Access then creates a copy of the database in the .accdb format.

Note: You cannot use the .accdb file in versions of Access earlier than Office Access 2007.

From:

https://support.office.com/en-us/article/Convert-a-database-to-the-Access-2007-file-format-2FB6EE27-E776-492F-A26E-B2A44C6E8809#bm2
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question