Test Access Back-end corrupted

[giovanniroi]

Dear Friends, how can I test from my Access 2007 Front end if my DB Access 2007 back-end is corrupted and not available?.

Tnak's for the support

Regards

Giovanni Roi

 

[KenHigg]

Can you not repair the backend?

 

[giovanniroi]

Dear KenHigg,
my problem is not to repair the back-end ( I have more copy of the back-end ) but to give to the user the possibility to intercept by VBA code when the back-end is not accessible ( back-end corrupted).

Thank's
Regards

Giovanni Roi

 

[vbaInet]

I think you should be looking at the cause of the corruption instead of trying to detect it. Access DBs go corrupt for several reasons.

 

[KenHigg]

I'm in favor of spending time trying to figure out why it corrupts and correcting that...

Not sure how you could trap that kind of error though...

 

[vbaInet]

Not sure how you could trap that kind of error though...

And it also depends on what level of corruption So like Ken and myself have agreed, getting to the root cause is the right way to go.

There's a tool by Tony Toews that might be of interest. Google that.

 

[giovanniroi]

Dear Friends,
damage of the DB is very serious, Access are not able to recognizes the Access DB as a Access database.
I could not understand why the back-end is corrupted, also because this has happened while I was doing development work, when, after adding some features in Windows Vista enviromente, I delivered the application on Windows XP.

I have not done any action that may have caused damage to the back end.

But my problem now is not to investigate because the back-end is corrupted, but to add the VBA code to test from the front end if the back end is not accessible and to give a message to users about this error.

My application will be distributed to hundreds of users and the back-end corruption can happen over time and I want to add a feature that performs this test.

Thank's for the support

Giovanni Roi

 

[KenHigg]

Technically it sounds like you may not be sure if the BE is 'corrupt' or if if something else could be wrong, like version issues, etc.

 

[giovanniroi]

When I opened the DB corruption with Access 2007, Access has tried to correct the DB and show me that it was not possible to recover the DB. He also reported that the file was not recognized as an Access format (the name is: Develop.accdb).

But now I need only to write a code to test the Access back-end availability.

Regards

Giovanni Roi