Access Data Base Corruption is Frequent.

By vel_achary ·
Hi Tech Guys and Girls,

I am facing a very Frequent issue with my Data base corruption which is assigned in MSAccess 2003.
I have tried scanning my computer with a licensed and fully update antivirus(trendmicro)it didnt even shown me a single virus activity, I check from HiJackThis Still no clue of virus.
But the Corruption is so regular...
I tried keep tracking on what ever i do that do access of my database, still found no useful clue...

I found an alternative solution of Repairing the database but i need to do this everytime the corruption happen.

Does anyone know what are the reasons for such database corruption???
I would appreciate your help.

Sakthivel Achary

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

re : corruption

by El_Duce In reply to Access Data Base Corrupti ...

How large is the database?
Do you use memo fields?
do you use OLE-objects?

Collapse -

re : corruption

by vel_achary In reply to re : corruption

3 to 3.5MB Database.
No memo fields and OLE-objects used...

Collapse -

Wow, it's not the most robust db in the world

by Tony Hopkinson In reply to re : corruption

but it's usually better than that at that size.

Are you sharing it with other users, that's Access's other major weakness.

If not I'd be tempted to build a new database, the tables and then import the data and then throw the old one away.

You could also try dropping all keys and indexes and then putting them back on.

Unistall and reintall access, may be

Last but not least, install SQL 2005 Express, and then import the datbase into it and link the access front end to it.


Related Discussions

Related Forums