Fix Microsoft Access Error 3211 When Creating Table Relationships
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.
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.
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.
In Access, close any open tables, forms, reports, and queries that use either table. Then close the database and exit Access.
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.
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.
Reopen the database in Access, select Database Tools > Relationships, and create the relationship between the tables.
Compact and repair the Access database
Try this if the error continues after closing objects and clearing any stale lock.
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.

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.




