Error copying form "The database has been place in a state"

Question

I have 2 local Access 2016 database. I would like to copy a form from one database to the other.

When I try and pasted the copied form, I get the error "The database has been placed in a state by user....that prevents it being opened or locked.

As the databases are local, I am the only person with the database open, although both database contain linked tables.

Is there a way to overcome this issue?

Answer 1

To copy a form from one database to another, the database where the form resides need to not have any exclusive locks set. The simplest way to ensure this is to close the database, and open them up only to copy the form.

Things that cause exclusive locks include modifying table design, modifying forms, modifying VBA, or explicitly open up the database exclusively.