<div>
This sometimes happens when you have two database files open.<br />
Close one file, ...then try again...<br />
<br />
Else, open the folder the database resides in, ...and see if a locking file (.ldb or .laccdb) exists.<br />
If so, delete the locking file and try again...
</div>


This sometimes happens when you have two database files open.
Close one file, ...then try again...

Else, open the folder the database resides in, ...and see if a locking file (.ldb or .laccdb) exists.
If so, delete the locking file and try again...

<div>
Or even sometimes this will happen if you &quot;inadvertently&quot; open the same db file twice.<br />
<br />
Simply close one of the instances and try again...<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/10_w41/951965/Same-file.png" target="_blank" title="Same DB file opened twice (50 KB)"><img alt="Same DB file opened twice" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2015/10_w41/800_951965/Same-file.png" /></a><br />
Jeff
</div>


Or even sometimes this will happen if you "inadvertently" open the same db file twice.

Simply close one of the instances and try again...
Same DB file opened twicehttps://filedb.experts-exchange.com/incoming/2015/10_w41/951965/Same-file.png
Jeff

Same-file.png

<div>
<div class="content wysiwyg-content">
I get an error when trying to compact and repair database. &nbsp;See the screenshot.<a href="https://filedb.experts-exchange.com/incoming/2015/10_w41/951946/Capture.JPG" target="_blank" title="Capture.JPG (45 KB)"><img alt="Capture.JPG" class="file-block lazyload" style="max-width: 687px;" data-src="https://filedb.experts-exchange.com/incoming/2015/10_w41/951946/Capture.JPG" /></a>
</div>
</div>


Capture.JPG

I get an error when trying to compact and repair database.  See the screenshot.

error when trying to compact and repair database. acceb file already in use

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.