<div>
You can try to ensure that all active recordsets are closed and set to Nothing, then set db=Nothing before trying your repair.<br />
<br />

</div>


You can try to ensure that all active recordsets are closed and set to Nothing, then set db=Nothing before trying your repair.



<div>
<div class="content wysiwyg-content">
I have the code to compact and repair a database. But I receive the error 3356 the database is open.. What is the best way to close the database, if it is open. I have tried db.Close but it must be open somewhere else in the project. &nbsp;Any suggestions?
</div>
</div>


I have the code to compact and repair a database. But I receive the error 3356 the database is open.. What is the best way to close the database, if it is open. I have tried db.Close but it must be open somewhere else in the project.  Any suggestions?

Compact Repair Database (Close Database)

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.