<div>
And the kitchen sink is probably in there as well.<br />
<br />
I'll start dissecting this bit by bit but there's certainly enough info there to create what I'm looking for.
</div>


And the kitchen sink is probably in there as well.

I'll start dissecting this bit by bit but there's certainly enough info there to create what I'm looking for.

<div>
<div class="content wysiwyg-content">
VB6/Access97 application. &nbsp;For the most part my multi-user application works fine, but occasionally the database gets corrupted, or dubious data is generated.<br />
<br />
I'm creating a Database Maintenance form whereby Users can monitor the back end database and check all is well. &nbsp;I'm putting in routines to tidy up tables if known errors have occurred. &nbsp;There is also a standard DAO Compact and Repair facility ( much better I've found than using ADO/JRO ).<br />
Now, is there a way of telling whether a database is so corrupted/damaged that C &amp;&nbsp;R won't work? &nbsp;I looked at one the other day that I couldn't repair and the only way to restore it was to create a new database and import the tables in. &nbsp;The application was still working, so although Access recognised it had a problem it wasn't preventing normal reading and writing of data.<br />
<br />
Can VB look at an Access database and tell whether it's OK, slightly corrupted and in need of C &amp;&nbsp;R, or so corrupted that needs a blank database transfer?
</div>
</div>


VB6/Access97 application.  For the most part my multi-user application works fine, but occasionally the database gets corrupted, or dubious data is generated.

I'm creating a Database Maintenance form whereby Users can monitor the back end database and check all is well.  I'm putting in routines to tidy up tables if known errors have occurred.  There is also a standard DAO Compact and Repair facility ( much better I've found than using ADO/JRO ).
Now, is there a way of telling whether a database is so corrupted/damaged that C & R won't work?  I looked at one the other day that I couldn't repair and the only way to restore it was to create a new database and import the tables in.  The application was still working, so although Access recognised it had a problem it wasn't preventing normal reading and writing of data.

Can VB look at an Access database and tell whether it's OK, slightly corrupted and in need of C & R, or so corrupted that needs a blank database transfer?

Can VB tell the correct state of an Access 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.