access 2002 and network issue

  • Thread starter Thread starter mike
  • Start date Start date
M

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
 
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?
Click to expand...

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.
 
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
 
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?
Click to expand...

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.
 
Back
Top