UPDATED: Check MS Access DB for errors (via VB 6.0)

I have an application that uses a MS Access database. What I would like to do is have the database checked for errors during the program start-up routine. That way if errors are detected, the compact/repair routine can be run, or the user can roll back to previous back-up. What I want is a GENERIC VB 6.0 function that can open any Access 2000 database, figure out what tables exist, check them for any sort of errors and/or bad records and return true if errors are found. You can use the standard microsoft tradewind db or any other database you'd like for testing. Please use DAO in your VB function, it's what I use. The function should take the database path as input. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). * * *This broadcast message was sent to all bidders on Friday Oct 26, 2007 7:56:46 PM: Hello Bidders Okay, I'm getting bids from $9.00 to $3,000+, so obviously I didn't do such a good job explaining what I want. I will try again. First, I'm talking simple here, nothing complex. You are looking for corruption errors ONLY in MS Access, not for data or business rule errors in my records. I'm talking about errors that literally lock up Access if I attempt to open a record (since it is corrupted; this is why I want to flag the user to do a roll-back to a backup copy, rather than losing potentially more data as the day progresses). I want a simple function that checks that tables can be opened and that the records not corrupted (probably with a "movenext" loop, although I am not a database expert and I'm not 100% sure that would pick up a corruption error). Since it is hard to test if your code works, I will tend to favor the bidder who explains why it would work to pick-up corruption/database crash errors. Maybe what I am asking for is not possible; if so, let me know that also. Thanks for taking the time to bid on my project. David ## Platform MS Access 2000 VB 6.0