<div>
Once you get the A97 db into (ideally) A2010 ... and get it operation in A2010 - meaning all References are working and your VBA code compiles ... then ... create a blank A2013/A2016 container, and import all of your objects into that container and continue on ...<br />
<br />
At the moment, I would not recommend A2016 - as we are finding there are several bugs that need to be resolved my Microsoft.
</div>


Once you get the A97 db into (ideally) A2010 ... and get it operation in A2010 - meaning all References are working and your VBA code compiles ... then ... create a blank A2013/A2016 container, and import all of your objects into that container and continue on ...

At the moment, I would not recommend A2016 - as we are finding there are several bugs that need to be resolved my Microsoft.

<div>
You can do it in two steps. <br />
Use Access 2000 to convert to Access 2000 and Jet4. <br />
This you can convert directly with Access 2013 to the ACE (accdb) format.<br />
<br />
/gustav
</div>


You can do it in two steps.
Use Access 2000 to convert to Access 2000 and Jet4.
This you can convert directly with Access 2013 to the ACE (accdb) format.

/gustav

<div>
1. Make a backup copy.<br />
2. Compact and Repair.<br />
3. Ensure that it compiles.<br />
4. Convert.<br />
5. Compile again and check for errors. &nbsp; Some things that you may have used like the MS calendar control have been removed and replaced with something built-in.<br />
6. Test app functionality.<br />
<br />
Jim.
</div>


1. Make a backup copy.
2. Compact and Repair.
3. Ensure that it compiles.
4. Convert.
5. Compile again and check for errors.   Some things that you may have used like the MS calendar control have been removed and replaced with something built-in.
6. Test app functionality.

Jim.

<div>
<div class="content wysiwyg-content">
what is the best process to important a .MDB database from access 97 into a current database system. Im not sure what other questions I should be asking however I need to migrate over from access 97 database store to a more up to date system<br />
<br />
Suggestion?
</div>
</div>


what is the best process to important a .MDB database from access 97 into a current database system. Im not sure what other questions I should be asking however I need to migrate over from access 97 database store to a more up to date system

Suggestion?

Updating to a newer .mdb database

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.