?
Solved

convert an MSaccess 97 database stright to A2007

Posted on 2016-08-17
2
Medium Priority
?
43 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 48

Expert Comment

by:Dale Fye
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 31

Accepted Solution

by:
Scott C earned 1500 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Suggested Courses

752 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