Upgrading from Access 2003 to Microsoft 365: A Practical Migration Guide
Access 2003 was the last version to use the classic .mdb format and the old menu interface. Upgrading to Access 365 means a new file format, a new UI, and a few features that no longer exist. Here is how to do it right.
Access 2003 holds a special place in the hearts of many database developers. It was the last version before Microsoft overhauled the entire Office interface with the Ribbon, and it was the last version to use the .mdb file format by default. For many organisations, Access 2003 databases have been running reliably for 20+ years — and now the time has come to move on.
This guide covers everything specific to the Access 2003 → Access 365 upgrade path.
What Changed Between Access 2003 and Access 365
The jump from 2003 to 365 is significant but manageable. Here is a high-level summary:
| Area | Access 2003 | Access 365 |
|---|---|---|
| File format | .mdb (Jet 4.0) | .accdb (ACE engine) |
| Interface | Classic menus and toolbars | Ribbon |
| Security model | User-Level Security (.mdw) | Trust Center + file permissions |
| Max database size | 2 GB | 2 GB |
| Max field size (Text) | 255 characters | 255 characters (Short Text) |
| Memo fields | Up to 65,535 chars | Long Text (up to 1 GB) |
| Attachments | OLE objects only | Native Attachment field type |
| Multi-value fields | Not available | Available (use with caution) |
| Data macros | Not available | Available |
Features Removed Since Access 2003
User-Level Security
This is the most disruptive change for Access 2003 databases. If your database uses a workgroup file (.mdw) with user accounts and permissions, that entire security system was removed in Access 2007 and does not exist in Access 365.
When you convert a database that has User-Level Security, Access 365 will warn you that the security settings cannot be converted. The database will open, but all security restrictions will be gone — anyone who can open the file can see all the data.
What to do instead:
- For simple cases: use Windows file system permissions to control who can access the database file
- For proper security: migrate the back-end tables to SQL Server and use SQL Server authentication
- For a quick fix: build a VBA login form that restricts which forms users can open (not true security, but better than nothing)
Data Access Pages
Access 2003 had a feature called Data Access Pages — HTML files linked to your database that could be opened in Internet Explorer. This feature was removed in Access 2007. If your database includes Data Access Pages, they will not convert.
Modern alternatives: Power Apps, SharePoint lists, or a simple web front-end connected to a SQL Server back-end.
Pivot Table and Pivot Chart Views
Forms in Access 2003 had Pivot Table and Pivot Chart views. These were removed in Access 2013. If users relied on these views, replace them with linked Excel workbooks or Power BI reports.
The Ribbon: Getting Used to the New Interface
The single biggest shock for Access 2003 users is the Ribbon interface introduced in Access 2007. Everything moved. Here is a quick mapping of common tasks:
| Access 2003 location | Access 365 location |
|---|---|
| File → Compact and Repair | Database Tools → Compact & Repair Database |
| Tools → Relationships | Database Tools → Relationships |
| Tools → References (VBA) | VBA Editor → Tools → References |
| View → Toolbars | Right-click the Ribbon → Customize the Ribbon |
| File → Database Properties | File → Info |
| Tools → Analyze → Performance | Database Tools → Analyze → Analyze Performance |
The Navigation Pane (left panel) replaces the old Database Window. You can still see all your tables, queries, forms, reports, macros, and modules — they are just displayed differently.
Step-by-Step Conversion Process
1. Back Up Everything
Copy your .mdb file to a safe location. Also export any linked table connection strings to a text file so you can recreate them if needed.
2. Compact and Repair the Original
Open the .mdb in Access 2003 (or whatever version you currently have) and run Tools → Database Utilities → Compact and Repair. Fix any issues before converting.
3. Open in Access 365
Open Access 365 and use File → Open to open the .mdb file. Access will open it in compatibility mode — you will see "(Access 2002-2003 file format)" in the title bar.
4. Convert to .accdb
Go to File → Save As → Access Database (.accdb). Give it a new name and save it. Do not overwrite the original .mdb.
5. Compile and Fix VBA
Open the VBA editor (Alt+F11) and run Debug → Compile Database. Common errors in Access 2003 databases:
Missing references: Access 2003 databases often reference specific versions of DAO or ADO libraries. In Access 365, go to Tools → References and update any "MISSING" references to their current versions.
64-bit API declarations:
If your VBA code calls Windows API functions using Declare statements, they need updating for 64-bit Office:
' Access 2003 style (32-bit only)
Declare Function FindWindow Lib "user32" Alias "FindWindowA" _
(ByVal lpClassName As String, ByVal lpWindowName As String) As Long
' Access 365 compatible (32-bit and 64-bit)
#If VBA7 Then
Declare PtrSafe Function FindWindow Lib "user32" Alias "FindWindowA" _
(ByVal lpClassName As String, ByVal lpWindowName As String) As LongPtr
#Else
Declare Function FindWindow Lib "user32" Alias "FindWindowA" _
(ByVal lpClassName As String, ByVal lpWindowName As String) As Long
#End If
CreateObject and late binding:
Code that uses CreateObject("ADODB.Connection") or similar late-bound COM objects generally still works, but verify each one.
6. Check All Forms and Reports
Open every form in Design view and look for:
- Missing ActiveX controls — shown as empty boxes with an error icon
- Broken event procedures — click the
...button next to any event property to verify the procedure exists - Subform source objects — verify each subform's Source Object property still points to a valid form or query
Open every report in Print Preview with real data and check for:
- Incorrect grouping or sorting
- Missing calculated fields
- Truncated text in labels or text boxes
7. Test All Queries
Run every query and compare results to what you expect. Pay particular attention to:
- Action queries (Update, Delete, Append, Make-Table) — test with a small dataset first
- Crosstab queries — verify column headers are correct
- Queries with parameters — verify the parameter prompts still appear correctly
8. Set Up Trusted Locations
To prevent the security warning bar from appearing every time users open the database, add the folder containing the database to Trusted Locations:
File → Options → Trust Center → Trust Center Settings → Trusted Locations → Add new location
Do this on every machine that will run the database.
Handling the .mdb vs .accdb Decision
Some organisations choose to keep the .mdb format even in Access 365 — Access 365 can open and edit .mdb files. This is a valid short-term strategy if:
- You have many machines that still run older versions of Access
- You need to maintain backward compatibility with Access 2003 users
- You want to defer the conversion work
However, staying on .mdb means you cannot use newer Access 365 features like:
- The Attachment field type
- Multi-value fields
- Data macros
- The improved encryption (
.accdbuses a stronger encryption algorithm)
For most organisations, converting to .accdb is the right long-term choice.
After the Conversion: Quick Wins
Once your database is running cleanly in Access 365, take advantage of features that did not exist in Access 2003:
Attachment fields: Replace OLE objects in tables with the native Attachment field type. It stores files more efficiently and does not require the source application to be installed to view them.
Data macros: Add data macros to tables to enforce business rules at the data level — for example, automatically setting a "ModifiedDate" field whenever a record is updated.
Navigation Forms: Replace the old Switchboard with a modern Navigation Form (Create → Navigation) that gives your database a polished, tabbed interface.
The Trust Center and .accde: Compile your finished database to an .accde file (Database Tools → Make ACCDE) to lock the VBA code and prevent users from accidentally modifying forms or reports.
A Note on Performance
Access 365 on modern hardware is significantly faster than Access 2003 on the hardware it originally ran on. However, if your database has grown substantially since 2003, this is a good time to:
- Add indexes to fields used in query criteria and joins
- Run the Performance Analyzer (Database Tools → Analyze Performance)
- Consider splitting the database into a front-end (forms/reports) and back-end (tables) if you have not already done so
The Access 2003 to 365 migration is one of the more straightforward upgrade paths — the core database engine is compatible, and most VBA code survives with minor changes. The main work is dealing with User-Level Security and updating any Windows API declarations.
Work With Access Evolved
If you found this article useful, Access Evolved specializes in exactly this kind of work — from hands-on Microsoft Access support to full database modernization projects.
Upgrading from Access 2003 and considering whether to modernize further? Schedule a free call and explore your options.
Thinking about migrating?
Ready to move beyond Microsoft Access?
Access is a great starting point, but growing businesses often hit its limits. Anthony Passeri specializes in migrating Access databases to modern platforms — Power Platform, Power Apps, SQL Server, Azure, and more — so you keep your data and workflows without the headaches.
Written by
Anthony Passeri, MBA
Access Expert and Editor
Bridging the gap between Access and the Future
Explore Topics
Keep reading
More on Access Basics
Upgrading from Access 97 or Access 2000 to Microsoft 365: What You Need to Know
Still running a database built in Access 97 or 2000? Here is everything you need to know to bring it forward to Access in Microsoft 365 — what works, what breaks, and how to plan the migration.
Upgrading from Access 2007 or 2010 to Microsoft 365: Smoother Than You Think
Access 2007 and 2010 already use the .accdb format, so the upgrade to Access 365 is mostly about compatibility settings, VBA tweaks, and taking advantage of features you did not have before.
Converting .mdb to .accdb: The Complete How-To Guide
The .mdb format served Access users for over a decade, but .accdb is the modern standard. Here is everything you need to know to convert your database safely — and what to watch out for.