Clem Wilkins said:
Help. I have designed an Access database with one main data table. Now when I
try to open the table I get the following message 'Disk or network error'
and the table fails to open. Other look up table and temporary tables open as
usual. How can I resurrect the main table?
The error can be caused by a number of things, one of which is the lack of a
defined disk space for the Jet temp file. Usually, the cause is a corruption
which can be usually fixed by doing a Compact and Repair of the database.
First, always work on a COPY of the database. Working on the original may
make it impossible for a repair service to fix it.
Download a copy of JetComp.exe:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956
Also have a look at the Microsoft KB article:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137
Then have a look at Tony Toews' Access Corruption FAQ at:
http://www.granite.ab.ca/access/corruptmdbs.htm
for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.
Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:
http://www.pksolutions.com
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
