The Tool Desk
Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Protect an Access database by creating a dated backup copy, choosing a schedule that matches how often it changes, and knowing how to restore either the whole file or an individual object. Access has a built-in backup command; multiuser databases need coordination, split databases need separate front-end and back-end care, and Compact and Repair is not a substitute for a backup.
1. Use Access’s built-in Back Up Database command
Access can create a separate backup copy through its Save As workflow. The default filename identifies the source database and the backup date, which helps distinguish copies when you need to restore one. Microsoft documents this process for Access desktop databases in Protect your data with backup and restore processes and its Access backup walkthrough.
- Open the database you want to protect.
- Select File > Save As.
- Under File Types, choose Save Database As.
- Under Advanced, choose Back Up Database, then select Save As.
- Choose the destination and save the copy. Keep the generated source-and-date filename, or use a similarly clear name if you rename it.
Save the backup somewhere distinct from the working copy when practical. A copy next to the original may help with accidental changes, but it will not protect against loss of the storage location.
2. Set backup frequency according to how often the database changes
There is no single schedule that suits every database. Microsoft’s guidance distinguishes rarely changed archives or reference databases from active databases with frequent updates: a copy after a change may be sufficient for the former, while the latter need regular backups. Choose a routine based on how much recent work you could afford to lose.
Free tools Windows power users keep installed
One-click scans. No signup required.
#1 Best Overall
- Read Before You Buy — No Video Output: These adapters support charging and USB 2.0 data transfer, but cannot transmit video signals. Except for standard USB webcams (which use USB data only), they are not compatible with HDMI/DisplayPort cables, video-capable USB-C hubs, or docking stations with video output.
- Convert USB-A Ports to USB-C: Designed to connect USB-C earphones, cables, flash drives, card readers, and other USB-C accessories to standard USB-A ports. Plug-and-play with no drivers or software required.
- Aluminum Alloy Housing: Built with a sturdy aluminum alloy shell that aids in heat dissipation and protects against daily wear and scratches. Designed to maintain a stable and secure connection.
- Compact & Travel-Friendly: The ultra-compact design allows the adapter to stay plugged into your device without blocking adjacent ports or adding bulk, reducing wear and tear on your original USB ports.
- 12-Month Warranty: Backed by a 12-month manufacturer warranty for peace of mind. Designed to meet strict quality control standards for reliable everyday performance.
- Archive or reference database: Back it up when its data or design changes.
- Frequently updated database: Make copies on a regular schedule that fits its update rate and your acceptable data-loss window.
- Multiuser database: Make a copy after a design change, and coordinate the backup with users as described below.
Before an action query that changes or deletes records, consider creating a copy. Access Undo cannot reverse every change made by an action query. Microsoft covers these planning considerations in its backup and restore guidance.
3. Coordinate backups when other people use the database
For a shared database, have users close their databases before you make a backup so their changes are saved. A backup taken while others are working may not capture the state you expect, and a back-end backup of a split database specifically requires exclusive access.
- Tell users when the backup will happen.
- Ask them to save their work and close the database.
- Confirm that nobody is still using the database before starting the backup.
- Create the backup, then let users know when they can resume work.
Microsoft’s overview of shared Access desktop databases notes that a single shared file on a network drive is the simplest sharing approach, but concurrent editing can bring reliability, availability, performance, and security limitations. Sharing architecture is a deployment decision, not a backup: see Ways to share an Access desktop database.
Rank #2
- 5-in-1 USB-C Hub: Experience comprehensive connectivity featuring a Power Delivery input, two USB-A 2.0 ports, a USB-A 3.0 port, and an HDMI port. (Note: The USB-C power delivery input port is only for connecting an external wall charger to power your laptop and cannot power peripheral devices.)
- 90W Pass-Through Charging: Achieve optimal charging with 90W pass-through power to your laptop, supported by a total input of 100W, with the hub reserving 10W for operational efficiency. (Note: Wall charger not included.)
- Quick Data Transfers: Accelerate your productivity with rapid data transfers using a high-speed 5Gbps USB 3.0 port and two 480Mbps USB 2.0 ports.
- 4K HDMI Display: Enhance your visual experience with a hub capable of delivering 4K resolution at 30Hz in both mirror and extend modes. Please note that this hub is compatible with MacBook (macOS 12 and newer), Windows 10 and 11, ChromeOS, and laptops equipped with DP Alt Mode and Power Delivery. Note: This device is not compatible with Linux.
- What You Get: Anker USB-C Hub (5-in-1, 4K HDMI), welcome guide, 18-month warranty, and our friendly customer service.
4. Back up a split database’s back end with exclusive access
A split database separates the tables that hold data into a back end from the queries, forms, reports, and other objects in a front end. Users typically work through local copies of the front end that connect to the shared back end. For the back-end backup, Microsoft instructs you to open the back-end database exclusively and use Access’s built-in backup workflow.
Quick wins for a faster PC:
Scan for outdated or missing drivers - takes under a minuteDriver Scan →Repair Windows errors before they cause bigger problemsFix Now →- Notify users that the back end will be unavailable during the backup.
- Make sure users have closed their front ends and are no longer connected.
- Open the back-end database with exclusive access.
- Use File > Save As > Save Database As > Back Up Database, then choose the backup destination.
Microsoft’s split database guidance also recommends backing up before splitting. Data changed during the splitting process may not be reflected in the resulting back end, so do not treat splitting as a backup operation.
5. Back up the front end after design changes
The front end contains database objects users interact with, such as forms, reports, and queries. Because the back end and front end protect different things, a back-end copy does not preserve front-end design changes. Microsoft recommends backing up the front end after a design change; use the same built-in backup command on the relevant front-end file.
Rank #3
- Sleek 7-in-1 USB-C Hub: Features an HDMI port, two USB-A 3.0 ports, and a USB-C data port, each providing 5Gbps transfer speeds. It also includes a USB-C PD input port for charging up to 100W and dual SD and TF card slots, all in a compact design.
- Flawless 4K@60Hz Video with HDMI: Delivers exceptional clarity and smoothness with its 4K@60Hz HDMI port, making it ideal for high-definition presentations and entertainment. (Note: Only the HDMI port supports video projection; the USB-C port is for data transfer only.)
- Double Up on Efficiency: The two USB-A 3.0 ports and a USB-C port support a fast 5Gbps data rate, significantly boosting your transfer speeds and improving productivity.
- Fast and Reliable 85W Charging: Offers high-capacity, speedy charging for laptops up to 85W, so you spend less time tethered to an outlet and more time being productive.
- What You Get: Anker USB-C Hub (7-in-1), welcome guide, 18-month warranty, and our friendly customer service.
6. Make a copy before action queries that change or delete data
An action query can update or delete records, and Undo cannot restore every such change. Before running one, save a separate copy of the database so you have a known-good version to return to if the result is not what you intended. This is especially useful before a consequential data operation; it is not a replacement for your regular backup schedule.
7. Back up before Compact and Repair
Compact and Repair is a maintenance and recovery operation, not a backup method. Microsoft warns that “During the repair process, Access may truncate some data from tables that are damaged.” Create a backup immediately before running it, and ensure the database is not in use because the operation requires exclusive access. See Microsoft’s Compact and Repair guidance.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
You can run Compact and Repair manually on an open or closed database, or configure it to run when the database closes. Automatic compact-on-close can momentarily disrupt availability in a multiuser database. If repair is only partially successful, Access records objects it could not repair in MSysCompactErrors. When you have a previous backup, that table can help identify objects to import into the repaired database.
Rank #4
- Dual Converters, Infinite Potential：Includes 2× USB C male to USB A female adapters and 2× USB A male to USB C female adapters. Perfect for a wide range of uses—tablets with Bluetooth keyboards, expand USB ports on macbook, and more. Two different converters for all your daily needs
- Next-Level 10Gbps & 3A Charging: No more slow 480Mbps, this usb to usb c adapter has a transfer speed of up to 10Gbps, allowing you to do more transferring in less time. This usb adapter fits both USB A and USB C charger, supporting up to 3A fast charging
- Upgraded Exquisite Craftsmanship: With an aluminum alloy housing and metal connector, the usbc to usb adapter is extremely durable and sturdy. Rigorously tested to withstand more than 10,000 times of plugging and unplugging, ensuring long-lasting performance
- Broad Compatible: The usb c to usb adapter widely supports all USB C/ USB A devices like laptops, tablets, cellphones, car chargers, and phone chargers. Such as compatible with MacBook Pro/Air 2023/2022, Thunderbolt 4/3 Devices,Apple MagSafe Watch 9/8/7/SE/Ultra, iPad Pro 2022/2021, Samsung Galaxy S23/S20/S10, and iPhone 17/16/15 Pro. Plug and play
- Please Note: To reach 10Gbps speed, keep the cable under 3.3 ft. For USB A Male to USB C adapters, try flipping the USB C connector. USB C Male to USB A adapters support bidirectional 10Gbps transfer within 3.3 ft
8. Keep a known-good copy somewhere separate
A backup is useful only if it is a copy you trust and can retrieve. Microsoft gives a USB external backup device as one possible destination for a known-good copy. An external drive is a storage destination, not an automatic backup process: you still need to create and manage the copy.
Microsoft says you can save an Access database in OneDrive or a SharePoint document library, but recommends avoiding opening it directly from those locations. A file may be downloaded locally for editing and uploaded after saving; when multiple people open it, multiple copies and unexpected behavior can result. The warning applies to single and split databases and formats including .accdb, .accdc, .accde, and .accdr. Do not assume that opening or syncing a live Access file there is a complete backup strategy. Read Microsoft’s sharing guidance and its SharePoint data guidance.
How do I restore an Access database from a backup?
First identify a backup whose data and design you trust. The restore method depends on whether you need the complete database or only one object. Microsoft describes both options in its backup and restore instructions.
Best Value
- 5-in-1 Connectivity: Equipped with a 4K HDMI port, a 5 Gbps USB-C data port, two 5 Gbps USB-A ports, and a USB C 100W PD-IN port. Note: The USB C 100W PD-IN port supports only charging and does not support data transfer devices such as headphones or speakers.
- Powerful Pass-Through Charging: Supports up to 85W pass-through charging so you can power up your laptop while you use the hub. Note: Pass-through charging requires a charger (not included). Note: To achieve full power for iPad, we recommend using a 45W wall charger.
- Transfer Files in Seconds: Move files to and from your laptop at speeds of up to 5 Gbps via the USB-C and USB-A data ports. Note: The USB C 5Gbps Data port does not support video output.
- HD Display: Connect to the HDMI port to stream or mirror content to an external monitor in resolutions of up to 4K@30Hz. Note: The USB-C ports do not support video output.
- What You Get: Anker 332 USB-C Hub (5-in-1), welcome guide, our worry-free 18-month warranty, and friendly customer service.
Restore the whole database file
For a missing, damaged, or data-problematic database, replace the affected file with the known-good backup copy. If other databases or programs link to that file, restore it to the expected location; moving it elsewhere can break those links, which may then need updating.
Restore one object
If only an object is missing or damaged, import that object from the backup into the current database rather than replacing the entire file. Check its location and any links that depend on it.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
