Fix Missing Access Database Data After Copying to a USB Drive
Question details
Users experience missing table data when opening a Microsoft Access database that was copied to a USB flash 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.
Ensure that Microsoft Access is completely closed before attempting to copy any files to prevent incomplete transfers or data corruption.
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.
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.
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.
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.
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.

Fully Close Access Before Copying
Use this basic troubleshooting step if your database is a single file but data still fails to copy correctly.
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. Download the Free Installer: Visit the official WPS Office website and download the installation package tailored to your operating system.
- 2. Install and Open: Run the setup file. Once installed, WPS Office will automatically detect and allow you to edit standard Office files seamlessly.

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.




