Others

Fix Microsoft Access Error 3211 When Creating Table Relationships

Muhammad TalhaMuhammad Talha Nov 14, 2026 868 views

Question details

Resolve error 3211 so a table relationship can be created in Microsoft Access.

Product
Microsoft Access
Device & OS
not provided
Scenario
The user is creating a relationship between tables in an Access database.
Observed behavior
Access reports that a table is in use by another person, although no other user appears to be connected.
Before you start

Identify the database file and its folder, and confirm that everyone has closed the database, including on other computers if it is shared. Before deleting a stale locking file or running Compact and Repair, make a copy of the database file.

Solution 1Recommended

Close Access objects and clear a stale locking file

Use this approach when an open object, remaining Access process, or stale lock may be preventing the relationship change.

1
Close objects using the tables

In Access, close any open tables, forms, reports, and queries that use either table. Then close the database and exit Access.

2
Check for remaining processes

On Windows, open Task Manager and look for a remaining Microsoft Access or MSACCESS.EXE process. After confirming it is not being used, select it and choose End task.

3
Remove a stale lock file

In File Explorer, open the database folder. If all users and Access processes have closed the database but its matching .laccdb file remains, delete that locking file. Older .mdb databases may use an .ldb file instead.

4
Create the relationship

Reopen the database in Access, select Database Tools > Relationships, and create the relationship between the tables.

Do not delete an active lock file: A locking file can be in use by someone connected from another computer. Delete it only after confirming that the database is closed for everyone.
Free Microsoft Office alternative

Work with Office files in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with common Office files. It does not fix Access error 3211 or replace Access for creating database relationships.

Open and edit Word, Excel, and PowerPoint formats such as DOCX, XLSX, and PPTXUse a familiar interface for an easier move from Microsoft OfficeWork with table data in spreadsheets alongside your Access database workflowUse a free, lightweight suite for everyday documents and presentations
microsoft office alternative - wps office

Frequently Asked Questions

Why does Access say a table is in use when nobody else is connected?

An open form, query, or table, a remaining Access process, or a stale locking file can keep Access from changing the relationship. Close the objects and check for remaining processes before trying again.

Is it safe to delete an Access .laccdb file?

Delete it only if it remains after everyone has closed the database and all associated Access processes have stopped. Do not delete a locking file while the database is in use.

Where do I create the table relationship again?

Open the database in Access and select Database Tools > Relationships. Close any forms or queries that use the tables before creating the relationship.

What should I do if the error continues after removing the lock file?

Make a copy of the database, open it exclusively through File > Open > Browse, and select File > Info > Compact & Repair Database. Then retry the relationship.