Possible DB corruption

[RipperT]

I have 7 .mdb front end files all connected to the same back end. None of
the front ends will allow me to right click a form and choose Save As.

Error msg is: File not found: 'C:\DOCUME~1\SmithSR\LOCALS~1\Temp\VB32.tmp'

Click OK, second error msg: Name conflicts with existing module, object or
project library.

Don't know when it started with each. Have stepped thru Allen Browne's tips
(and others) for recovering from corruption with no difference. Here is some
info I think may be significant: If I create a new .mdb under the same
workgroup, I can create forms and use the Save As command on each of them
without any trouble. When I import forms from any of the aforementioned
front ends, I can use Save As on them, too, until I close the new database
file and re-open it. Then the ones I created continue to behave, but the
ones I imported will not allow Save As...with same error msg. All front ends
are working and users are happy. It only occurs with forms, not reports or
other objects. Does this sound like corruption? I am looking into how to
rebuild them, but any help would be very appreciated.

Ripper

 

[Arvin Meyer [MVP]]

Here's all my tips:

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Decompile your database:
http://www.trigeminal.com/usenet/usenet004.asp

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

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

 

[RipperT]

Is there a JetComp utility for Jet 5.x?

R

Here's all my tips:

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Decompile your database:
http://www.trigeminal.com/usenet/usenet004.asp

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

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
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Arvin Meyer [MVP]]

Is there a Jet 5.x? I think the highest version of Jet is 4.0. The latest
version of JetComp will handle that.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[RipperT]

Yes, sorry, I was reaching. Turns out an XP SP3 installation took care of
the problem. Many thanks.

R