File Sharing Problems

Fix Missing Access Database Data After Copying to a USB Drive

Elise WilliamsElise Williams Nov 4, 2026 871 views

Question details

Users experience missing table data when opening a Microsoft Access database that was copied to a USB flash drive.

How to Fix Missing Access Database Data After Copying to a USB Drive
Product
Microsoft Access
Device & OS
not provided
Scenario
Transferring an Access database from a computer to a portable USB drive for backup or use on another device.
Observed behavior
The copied database opens with forms, queries, and links intact, but the actual data tables are missing or inaccessible.
Before you start

Ensure that Microsoft Access is completely closed before attempting to copy any files to prevent incomplete transfers or data corruption.

Solution 1Recommended

Copy Both Front-End and Back-End Files and Relink Tables

Use this solution if your Access database is split into a front-end interface and a back-end data file.

A split database separates the interface (forms, queries, reports) from the actual data tables. If you only copy the front-end file to your USB drive, the tables will appear empty or inaccessible because the back-end file containing the data was left behind.

1
Identify linked tables

Open your database in Microsoft Access and look at the Navigation Pane. If the table icons have a small arrow on them, the database is split, and the tables are linked from an external file.

2
Find the back-end file path

Press Ctrl+G to open the Immediate window. Type '? CurrentDb.TableDefs("NameOfLinkedTable").Connect' (replace NameOfLinkedTable with the actual name of any linked table) and press Enter. The result will display the full file path to the back-end database.

3
Copy both files to the USB drive

Navigate to the file path revealed in the previous step. Copy the back-end file, along with your front-end file, and paste both into your USB drive.

4
Relink the tables

Open the front-end database from the USB drive. Go to the External Data tab, select Linked Table Manager, select all the linked tables, and refresh their links to point to the new back-end file location on your USB drive.

Copy Both Front-End and Back-End Files and Relink Tables
Relinking Tip: Always keep the front-end and back-end files in the same relative folder structure on your USB drive to make relinking easier in the future.
Free Microsoft Office alternative

Manage Your Office Files Easily with WPS Office

While Microsoft Access is required for specialized .accdb databases, WPS Office provides an exceptional free, lightweight, and powerful alternative for handling your Word, Excel, and PowerPoint documents. Enjoy a familiar interface and seamless format compatibility without the high costs.

  1. 1. Download the Free Installer: Visit the official WPS Office website and download the installation package tailored to your operating system.
  2. 2. Install and Open: Run the setup file. Once installed, WPS Office will automatically detect and allow you to edit standard Office files seamlessly.
Highly compatible with Microsoft Office formats including DOCX, XLSX, and PPTXFree and lightweight alternative to standard, resource-heavy office suitesFamiliar user interface for seamless migration without any learning curveBuilt-in PDF tools for easy document sharing and secure file transfers across devices
microsoft office alternative - wps office

Frequently Asked Questions

Why does my copied Access database only show forms and not data?

This happens when your database is split into a front-end and back-end file. Copying only the front-end transfers the layout (forms, queries) but leaves behind the back-end file that actually stores the table data.

How do I know if my Microsoft Access database is split?

Look at the table icons in the Navigation Pane. If the tables have a small arrow on their icon, they are linked tables, indicating that the database is split and pulling data from another file.

What happens if I copy an Access database while it is open?

Copying an open database can result in an incomplete file transfer, data corruption, or missing recent changes, because the application temporarily locks the file to write data.