Corrupt DB

[AFKAFB]

All
I'm convinced my DB is either possessed by the devil or ir corrupt.

I ve no ides how long ago my corruption may have occured so i decided
to salvage what i could from my current DB and start again.

The forms are the most complex so i imported only the forms to a new
database. I then stripped these forms of all code, control sources,
formula, etc. and imported these shell forms into a new a DB.

And started again.

During the rebuild i regularly used the Compact & Repair DB and
Performance Analyser function. There was no problem but just now
whilst using the Performance Analyser there was an error and Access
rebooted. Theres been no problems since but i'm wondering if perhaps
the shell forms were not as clean as i thought and in fact are
'carrying' the earlier corruption.

Would that make sense?

Also doed my rebuild approach make any sense.

I could stat from scratch nut the forms took ages to get right and
doing them again fils me with dread..

regards

chris

 

[AFKAFB]

Arvin
I coped your code into my DB.
I selected run and typed DocDatabase in the immediate window and this
message was returned

'Compile Error - User defined-type not defined'

What am i doing wrong please.

chris

 

[Arvin Meyer [MVP]]

Arvin
Should the application.loadfromtest code be insert in a module in the
DB where the objects were saved from or sent to a new one.
i would have thought a new one but this has me stumped.
regards
chris

It's LoadFromText (not test). I'd add the module to a new empty database and
import the objects into the new one.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access