UK tech experts · info@vividrepairs.co.uk
Vivid Repairs
A Windows laptop on a desk showing Microsoft Access error dialog box with 3343 code and unrecognized database format message, blue office lighting, focused technical atmosphere
Fix It Yourself · Troubleshooting

Access error 3343 unrecognized format

Updated 11 June 202611 min read
As an Amazon Associate, we may earn from qualifying purchases. Our ranking is independent.

You open your Access database file and get hit with error 3343. The file won't load. Your database is suddenly inaccessible, and you're not sure if it's corrupted, outdated, or locked. Frustrating doesn't cover it. Here's the straight answer: this error usually stems from version incompatibility, file corruption, or network lock file issues. The good news is that most of the time, Access error 3343 unrecognized format responds to straightforward fixes without losing your data.

TL;DR

Access error 3343 unrecognized format happens when Access can't read your database because of version mismatch, corruption, or lock files. Fix it by (1) checking your Access version, (2) deleting .laccdb lock files, (3) running Compact and Repair, or (4) importing to a fresh database. For network setups, disable SMB leasing on the server. Success rate: 70-90% depending on corruption severity.

⏱️ 13 min read✅ 85% success rate📅 Updated May 2026

Key Takeaways

  • Error 3343 is almost never permanent data loss; it's a format recognition problem
  • Version incompatibility is the most common cause (newer .accdb opened in older Access)
  • Lock files (.laccdb or .ldb) can accumulate and block access after improper shutdown
  • Compact and Repair fixes light corruption but may not work for severe damage
  • SMB leasing changes on Windows servers after updates can break shared database access
  • Importing to a new database preserves data and works when Compact and Repair fails

At a Glance

  • Difficulty: Medium
  • Time Required: 45 mins
  • Success Rate: 85% of users

What Causes Access error 3343 unrecognized format?

This error appears when Access encounters a database file it can't parse. The database file itself might be intact, but something in how Access is trying to read it goes wrong. Four main culprits show up repeatedly.

First, version mismatch. You create a database in Access 2019 or 2021 (which saves as .accdb format), then try to open it in Access 2010 or 2013. Those older versions don't understand the newer format structure. Error 3343. Same problem happens with .mdb files created in very old Access versions and opened in much newer ones, though this is less common now.

Second, file corruption. A sudden power loss, malware infection, or incomplete conversion leaves the database file partially broken. The file still exists, but the internal structure is damaged enough that Access can't read the header or metadata. Corruption usually happens during writes (saving changes), not reads, so the damage accumulates over time if you keep saving to a corrupted file.

Third, lock files stuck around. When you close Access improperly (force quit, network disconnect, system crash), the .laccdb file (or .ldb for older formats) doesn't get deleted. That lock file tells Access the database is still in use. Next time you try to open it, Access sees the lock file and refuses to open the database because it assumes someone else has it open. The error appears even though no one is actually using it.

Fourth, SMB leasing on network file servers. Windows and Office updates in the last few years changed how file locking works on shared drives. If your database lives on a network server and multiple people access it, the SMB protocol now handles leasing differently. This can make Access unable to properly read or lock the file, triggering error 3343 for seemingly random users or at random times.

Access error 3343 unrecognized format: Quick Fix

1

Delete Lock Files and Upgrade Access Easy

  1. Check your Access version: Open Access. Go to File > Account. Write down the version number you see (e.g., 16.0 = Access 2016, 17.0 = Access 2019, Microsoft 365 = latest). This tells you whether your Access is new enough to open the database.
  2. Locate and delete lock files: Navigate to the folder containing your database file on your computer or network drive. Look for files named with your database name plus .laccdb (newer format) or .ldb (older format). Delete these lock files. Wait 10 seconds after deletion before proceeding.
  3. Attempt to open the database: Now open Access and try to open your database file again. If it opens without error 3343, you're done. The lock files were the problem.
  4. If still fails, upgrade Access: If error 3343 persists and your Access version is more than 2 versions older than when the database was created, you need a newer version. Go to File > Account > Update Options > Update Now to get the latest patches, or consider upgrading Access entirely.
✓ Success: Database opens without error 3343 and lock files are gone. Check the database folder and confirm no .laccdb or .ldb files reappear.

More Access error 3343 unrecognized format Solutions

2

Run Compact and Repair Easy

  1. Backup your database first: Copy your database file to a separate folder or external drive. This backup protects you if Compact and Repair encounters a serious issue. Do not skip this step.
  2. Open Access without the database: Open Microsoft Access as a blank application. Do not try to open the database file yet.
  3. Navigate to Compact and Repair: Click File > Info > Compact & Repair Database. A file browser opens.
  4. Select your database: Browse to and select the problematic database file. Click the Repair or Compact & Repair button (exact name varies by Access version).
  5. Wait for the process: Compact and Repair runs in the background. For databases under 100 MB, this typically takes 2-5 minutes. Larger databases take longer. A message appears when complete.
  6. Test the database: Open the database in Access normally. Check a few tables to confirm data is intact and error 3343 no longer appears when opening or navigating.
✓ Success: Database opens without error 3343. Data is preserved, and file size may have reduced slightly.
3

Import to a New Database Medium

  1. Create a fresh database: Open Access. Click File > New > Blank Database. Give it a temporary name like RepairTemp.accdb and save it to your desktop. Click Create. This opens a fresh, uncorrupted database file.
  2. Test this new database first: Close it and reopen it to confirm it works without error 3343. It should. If it does, proceed.
  3. Import from the problematic database: In the new blank database, go to External Data > New Data Source > From Database > Access. A dialog opens asking you to select a database file.
  4. Browse and select your original database: Navigate to your problematic database and select it. Click Open. A list of database objects (tables, queries, forms, reports) appears.
  5. Import tables first: Check the boxes next to all tables in your database. Click OK. Access attempts to import the table structures and data from the corrupted database into the new one. This takes a few minutes depending on database size.
  6. Check the imported data: After import, browse the tables to confirm data arrived intact. If some tables failed to import, they were too corrupted. Repeat the import process, selecting only the successful tables, then manually recreate the missing ones if needed.
  7. Import queries, forms, and reports: Repeat the import process for other objects (queries, forms, reports, macros). Import one object type at a time so you can identify which objects import successfully.
  8. Test and rename: Test all functionality in the new database. Once confirmed working, delete the old problematic database and rename the new one to the original name.
✓ Success: New database contains all recoverable data. Error 3343 no longer appears. Original corrupted file can be safely deleted.

Advanced Access error 3343 unrecognized format Fixes

4

Disable SMB Leasing on Network Servers (Multi-User Environments) Advanced

  1. Identify your file server: Determine which Windows server or network storage device hosts your shared database. This could be a dedicated file server, a network-attached storage (NAS) device, or a shared network folder on another Windows machine.
  2. Get administrator access to the server: You need local administrator rights on the server itself, not just on your client machine. Contact your IT department if you don't have this access.
  3. Open Command Prompt as administrator on the server: Log into the server (if remote, use Remote Desktop Connection). Right-click Command Prompt and select Run as Administrator. A command window opens with elevated privileges.
  4. Run the DisableLeasing registry command: Paste this entire command into the command prompt window: REG ADD "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanserver\parameters" /v DisableLeasing /t REG_DWORD /d 1 /f Press Enter. The output should say "The operation completed successfully."
  5. Restart the server: Run shutdown /r /t 30 to restart the server in 30 seconds. This gives connected users time to save their work. Alternatively, use the graphical Start menu to restart normally. All connections will disconnect during the restart.
  6. Verify the fix: After restart, test opening the database from multiple client machines simultaneously. If users can open it without error 3343, the SMB leasing fix worked.
  7. Document this change: Add a note to your IT documentation that SMB leasing is disabled on this server for Access database compatibility. This is important for future troubleshooting.
✓ Success: Multi-user database access works without error 3343. SMB leasing no longer blocks concurrent file access.
5

Verify VBA References and Run Diagnostics Advanced

  1. Check database references (VBA): If your database contains macros or custom code, open it in Access. Press Alt + F11 to open the VBA editor. Go to Tools > References. Look for any missing references (marked with "MISSING:"). Uncheck any missing references and ensure "Microsoft Office XX.0 Access Database Engine Object Library" is checked (not legacy DAO).
  2. Recompile all VBA code: In the VBA editor, go to Debug > Compile [DatabaseName]. This recompiles all code and can fix runtime issues that trigger error 3343 in certain code paths.
  3. Disable file compression: Navigate to where your database file is stored. Right-click the drive or folder, select Properties. If you see a checkbox for "Compress this drive to save disk space," uncheck it. Compressed drives can cause file reading issues. Decompression may take several minutes for large drives.
  4. Run disk diagnostics: Open Command Prompt as Administrator. Run chkdsk C: /f /r (replace C: with the actual drive letter). This schedules a disk check on the next restart. Restart your computer. The scan runs before Windows loads. Large drives take 30+ minutes. Let it complete.
  5. Check file path and move database: Ensure your database file path contains no spaces or special characters. If the path is C:\Users\John\My Files\database.accdb, move it to C:\Users\John\database.accdb or C:\Data\database.accdb. Paths with spaces occasionally cause parsing errors in older Access versions.
  6. Test again after diagnostics: Try opening the database. If error 3343 still appears and you've tried all other solutions, consider that the file may be beyond repair. Restore from your backup or contact a data recovery specialist. Professional tools like Aryson Access Recovery can sometimes recover databases that standard repairs cannot.
✓ Success: VBA references are valid, disk is healthy, and database opens without errors. File path is optimised for Access compatibility.

When to Consider Data Recovery Tools

If you've worked through the quick fix, Compact and Repair, and the import method with no success, the database file is likely severely corrupted. This happens occasionally with sudden power losses during database writes, especially on older hard drives with bad sectors.

At this point, standard Access repair features cannot help. Data recovery software designed specifically for Access files can sometimes extract tables and data from corrupted .accdb or .mdb files when normal methods fail. These tools read the raw file structure and attempt to reassemble tables even if the database header is damaged. This isn't a guaranteed fix, but it's worth exploring before accepting total data loss.

Common scenarios where recovery tools help: sudden power loss during a save operation, ransomware encryption, overwritten sectors on a failing drive, or severe corruption that Compact and Repair logs as "unrepaired."

Preventing Access error 3343 unrecognized format

Once you've fixed error 3343, avoid it happening again.

Start with version discipline. If you use Access 2016, keep all databases in .mdb or .accdb format compatible with that version. Don't randomly upgrade Access versions. When you do upgrade, use Database Tools > Convert to proactively convert databases to the new format before opening them. This prevents surprises.

Backup religiously. Before you edit any database, go to File > Save As > Back Up Database. Access creates a timestamped backup copy. Do this before making structural changes (adding tables, modifying forms) or large data edits. If something goes wrong, you've got a restore point.

Close databases properly. Don't force-quit Access or pull the network cable while a database is open. Always use File > Close or quit Access normally. When sharing databases over a network, close them at the end of your workday rather than leaving them open indefinitely. Unplanned disconnections leave lock files behind.

Disable compression on database folders. Right-click the folder containing your databases, select Properties, and ensure the "Compress this folder" option is unchecked. Compression can interfere with the large metadata reads Access performs. Use SSDs instead of older mechanical drives where possible; SSDs have fewer read errors and bad sector failures that corrupt databases.

Keep Office and Access updated. Run File > Account > Update Options > Update Now monthly. Security patches and bug fixes address issues like the SMB leasing problem that triggered error 3343 in many organisations.

For multi-user setups, split your databases. Instead of everyone connecting to a single monolithic database, create a front-end database (forms, reports, user interface) on each user's machine and a back-end database (tables and raw data) on the network server. This reduces simultaneous file locking, decreases corruption risk, and makes error 3343 far less likely. Limit concurrent users to 5-10 if you can't split; Access degrades significantly with 15+ simultaneous users on a shared file.

Access error 3343 unrecognized format Summary

Access error 3343 unrecognized format stops you cold, but it's almost never permanent data loss. The error comes from version mismatches, lock file remnants, file corruption, or SMB leasing issues on shared drives. Your database is still there; Access just can't read it right now.

The quick fix works 70% of the time: delete lock files and upgrade Access if needed. If that fails, Compact and Repair fixes light corruption. If both fail, import to a new database preserves your data whilst bypassing the corrupted file. For network environments, disable SMB leasing on the server. Only when all else fails should you consider that the file is beyond recovery and reach for specialised data recovery tools.

Going forward, maintain version discipline, back up before edits, close databases properly, disable drive compression, and split your databases for multi-user access. These habits eliminate most causes of Access error 3343 unrecognized format before they start.

Frequently Asked Questions

Error 3343 indicates Access cannot recognise the database file format. This typically occurs due to version incompatibility (opening a newer .accdb in older Access), file corruption from sudden shutdowns or malware, or network issues preventing proper file access on shared servers.

Yes. The Compact and Repair function and importing to a new database are non-destructive methods that preserve data whilst fixing format recognition issues. Always backup first before attempting any repair method.

Recent Windows and Office updates introduced SMB leasing changes affecting shared databases on network servers. These changes prevent proper file locking and reading. Disabling SMB leasing on the server resolves this issue for multi-user environments.

Yes, but only when no users are accessing the database. These lock files should be deleted if they remain after improper closure or network disconnections. They prevent the database from opening correctly on subsequent attempts.

.mdb is the older Access format (pre-2007), whilst .accdb is the newer format (2007 and later). Opening an .accdb file in older Access versions causes error 3343. Always check your Access version before attempting to open a database.