Re: Is my mdb corrupted ?
- From: "David F. Cox" <davidfcox@xxxxxxxxxxxx>
- Date: Fri, 28 Jul 2006 19:26:27 GMT
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
"Jim Burke in Novi" <JimBurkeinNovi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:962E21CE-26B4-4F99-9A26-CB9EF9CA1128@xxxxxxxxxxxxxxxx
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.
"Wellie" wrote:
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.
.
- Prev by Date: Re: Need help with sending record to Word from Access
- Next by Date: Re: Form won't update blank field
- Previous by thread: Need help with sending record to Word from Access
- Next by thread: Re: Is my mdb corrupted ?
- Index(es):
Relevant Pages
|
