Is my mdb corrupted ?

[Guest]

My BIG question:
IS MY MDB CORRUPTED RESULTING IN THESE PROBLEM AND ERROR MESSAGE ?

If so, is it safe to copy the tabe with structure and data onto a new DB ?

I searched on the internet, a couple of search results indicated that my mdb
is badly corrupted when seeing these error messages.

Here are the symptoms/indications:
On a couple of forms, when I click [...] to create an event procedure, I
received an error message:
"xxxx failed to create the Visual Basic Module."
"If you database is on a network drive, check your network connection,
and then try again."

My mdb appl is on my local drive. On the same form, when I tried to add a
new field or changin the Tab Index in the subform (named "Parts") , the
results of the following existing computed fields:
Detail Section:
* Material_Weight (with a formula: =[æ¯ä»½é‡é‡]*Forms!工程單!份數 (i.e.
=[unit_weight]*Forms!WorkOrder!Qty)
Footer Section:
* Material_Total_Weight (with a formula: =sum([æ¯ä»½é‡é‡]) (i.e.
=sum([Unit_Weight])

In addition, when I try to sum the "Material Total Weight" column with
formula:
* Material_Grand_Weight (with a formula: = sum(Material_Weight)

will mysterious shows an error "#Name?" instead of the calculated results.
Still don't know why it is happening ... - Plz help if you know why ???

In the mainform, when I tried to retirebe the result of these two fields
(Material_Total_Weight & Material_Grand_Weight) with the following formulas:
=[Parts].Form!Material_Total_Weight
=[Parts].Form!Material_Grand_Weight

I'll also get the "#Name?" error.


Please help.

 

[Guest]

I've had the same thing happen, and couldn't figure out what had happened. I
had to go back to a backup of my database - luckily I usually take at least
one backup per day for when things like this happen. You could try doing a
compact and repair and see if that fixes it. I haven't tried that before -
just thought of it. I have an mdb with the application and an mdb with the
data and I sometimes will open up both of them, and that seems to have caused
the problem for me in the past, so I never do that any more. If I have one
open and need to do something in the other, I close the one that's open. Good
luck.

 

[David F. Cox]

If you suspect that a database is corrupt then I suggest that the first
thing you do is back it up as it is, before trying any remedial action.

David F. Cox

I've had the same thing happen, and couldn't figure out what had happened.
I
had to go back to a backup of my database - luckily I usually take at
least
one backup per day for when things like this happen. You could try doing a
compact and repair and see if that fixes it. I haven't tried that before -
just thought of it. I have an mdb with the application and an mdb with the
data and I sometimes will open up both of them, and that seems to have
caused
the problem for me in the past, so I never do that any more. If I have
one
open and need to do something in the other, I close the one that's open.
Good
luck.

My BIG question:
IS MY MDB CORRUPTED RESULTING IN THESE PROBLEM AND ERROR MESSAGE ?

If so, is it safe to copy the tabe with structure and data onto a new DB
?

I searched on the internet, a couple of search results indicated that my
mdb
is badly corrupted when seeing these error messages.

Here are the symptoms/indications:
On a couple of forms, when I click [...] to create an event procedure, I
received an error message:
"xxxx failed to create the Visual Basic Module."
"If you database is on a network drive, check your network
connection,
and then try again."

My mdb appl is on my local drive. On the same form, when I tried to add
a
new field or changin the Tab Index in the subform (named "Parts") , the
results of the following existing computed fields:
Detail Section:
* Material_Weight (with a formula: =[????]*Forms!???!?? (i.e.
=[unit_weight]*Forms!WorkOrder!Qty)
Footer Section:
* Material_Total_Weight (with a formula: =sum([????]) (i.e.
=sum([Unit_Weight])

In addition, when I try to sum the "Material Total Weight" column with
formula:
* Material_Grand_Weight (with a formula: = sum(Material_Weight)

will mysterious shows an error "#Name?" instead of the calculated
results.
Still don't know why it is happening ... - Plz help if you know why ???

In the mainform, when I tried to retirebe the result of these two fields
(Material_Total_Weight & Material_Grand_Weight) with the following
formulas:
=[Parts].Form!Material_Total_Weight
=[Parts].Form!Material_Grand_Weight

I'll also get the "#Name?" error.


Please help.

 

[Len Robichaud]

Create a new (blank) database then, (using File, GetExternalData, Import,)
import everything from the suspected database into the new database. This
has usually worked for me in the past (only failing if the corrupted
database field due to large memo field corruption).

Len