VB3 problems opening Access 1.1 database
on Wed, 7 Aug 1996 08:56:18 GMT,
Walter Scott <Walter> writes:
Quote:
>I have a VB3 application that speaks to an Access 1.1 database. If a users
>machine
>crashes it can sometimes cause the application to fail to open the Access
>database.
>(I worked perfectly well before the crash)
>It will fail even after complete re-install of the application.
>Any suggestions please.
>Walter Scott
>_______________________________________________________
This problems appear when program crashes and leaves the DB corrupted.
As you have seen, Access is a 'delicate' database type. When you have this
kind of problem, you have to repair the database and compact it. If your
users have Access 1.1 installed, tell them to use it to repair AND compact
the database. If they haven't...hmmm... what I should do is:
- Try to open the database at the beginning of your app. If it returns an
error, that means that it's probably corrupted, and you may use
RepairDatabase and CompactDatabase from your application.
- But you could open the database without errors and that _wouldn't_ mean
it's free of them A suggestion is that periodically (that is, once a
week or once a day, or...) checking the date at the start of your app, you
could do a Repair and a Compact, even if the DB is OK...
Hope this helps,
Fernando.
