access 2002 and network issue

[mike]

Hi All,

I've been searching the knowledge base and the net, but I
can't find the answer I'm looking for. My question is, if
I place the access mdb file in a network share drive and
and using it. While I'm modifing(adding/deleting) the
records in the database and the network went down. What's
going to happen?

Thank you for your answers.

mike

 

[John Vinson]

Hi All,

I've been searching the knowledge base and the net, but I
can't find the answer I'm looking for. My question is, if
I place the access mdb file in a network share drive and
and using it. While I'm modifing(adding/deleting) the
records in the database and the network went down. What's
going to happen?

If you have been VERY good and VERY lucky, you will not have corrupted
the database at all; if you've been moderately good and are moderately
lucky, you will have corrupted the database in a way that either
Tools... Compact and Repair or JETCOMP.EXE can fix. If you have not...
get out your backup disk.

Access is very sensitive to network glitches, and this is a major
source of database corruption.

 

[mike]

By chances, the database can be corrupted and the tools
you mention can be used to repair the database? Where can
i find the tools?

Thanks,

mike

 

[John Vinson]

By chances, the database can be corrupted and the tools
you mention can be used to repair the database? Where can
i find the tools?

Compact and Repair is built right in to Access: open your database (if
it will open at all) and select Tools... Compact and Repair.

JETCOMP.EXE is a "super compact and repair" utility which can be
downloaded from Microsoft; it came in some Access service packs. Check
first to see if a file of that name is in your WINDOWS/SYSTEM (or
equivalent) folder; if not try

http://support.microsoft.com/?id=295334

Some corruption cannot be cured by either of these tools... hence
regular backups are essential.