Fix Microsoft Access Runtime Error 3343: Unrecognized Database Format
Question details
Resolve error 3343 when Microsoft Access cannot recognize a database file format.

- Product
- Microsoft Access and Access Runtime
- Device & OS
- not provided
- Scenario
- Opening or using an older Access database, potentially in a shared environment with SQL Server.
- Observed behavior
- Access reports runtime error 3343 and does not recognize the database file format.
Identify the affected file and its extension, such as .mdb or .accdb, and check which Access or Access Runtime versions users have installed. If the file is shared, ask users to close it before testing or repairing it.
Check the Access version and database format
Use this check to rule out a version or file-format mismatch before attempting a repair.
In File Explorer, locate the database and check whether its name ends in .mdb or .accdb. Do not change the extension to try to convert the file.
In Access, open File > Account > About Access to check the version. Compare it with the database format and the versions used by others.
Use File > Open > Browse in a compatible full version of Access to open the database. If it opens there, review the Runtime version and deployment used on the affected computer.

Compact and repair the affected Access database
Try Access's repair tool if the file format and version are compatible but the database may be damaged.
Investigate shared files and SQL Server connections
Use these checks when the error occurs in a shared database or a mixed Access and SQL Server environment.
Work with exported Access data in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface. Open exported data in WPS Spreadsheets and work with common Office files for an easier transition. WPS does not repair or replace an Access database.

Frequently Asked Questions
What does Access error 3343 mean?
It means Access cannot recognize the database file format. Possible causes include an incompatible Access version, an invalid file, or database damage.
Can I fix error 3343 by renaming .mdb to .accdb?
No. Changing the extension does not convert the database. Open the file in a compatible version of Access and use its conversion or save options if conversion is needed.
Can Access Runtime compact and repair a database?
Access Runtime does not provide the full Access interface. Open the database in a full version of Access and use File > Info > Compact & Repair Database when available.
What should I do if Compact and Repair does not work?
Test a known-good copy in a compatible Access version. If the database is shared, also check the network location and linked-table connections using External Data > Linked Table Manager.




