Corrupted Database

[BackAccess]

Hello NewsGroup,

I've been constructing an application UI using Access 2003. I've just
started it early this morning so it hasn't been backed up as yet. There are
no tables, queries, forms or report (didn't quite get to that stage). There
are 10 class modules and 5 modules only. While coding away I got an error
message, and Access had to restart, or gave me the option after the crash.

Now when I try to open any of the module sheets I get the following
disastrous message;

"MS Office Access has detected corruption in this file. Try to repair the
corruption, first make a backup copy of the file. Then, on the tools menu,
point to the Database Utilities and click Compact and Repair Database. If
you are trying to repair the corruption then you will need to recreate the
file or restore it from a previous backup."

| OK | Help |

Well didn't quite get to the end of a working day to back up the database. I
can't create another database and either import into it or export from the
database to the new one cause I get the same error message. Can't export the
module sheets otherwise I get the above error message.

Is there anything I can do to retrieve the module files? Any kind of Hex
file viewer or something as such I can retrieve the contents of the modules
file. My lessons have been learnt!!!!

Thank you all NewsGroup.

- BackAccess (I truly have been back accessed this time)

 

[Arvin Meyer [MVP]]

Typically, databases start with tables then move to queries before any code
is written. I'm not sure why you started by writing code, but I'll leave
that for another post.

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

 

[BackAccess]

Thanks Arvin very useful links ended up recoding it all from scratch,
nothing would recover the modules. I know what you mean where databases
start and finish, my part what to construct customised interface elements so
I had API function and some more. I even found what ruined the entire
database, make sure if you're ever doing the same to return a valid value
for your "hook procedures" and API function parameters, otherwise Access
just geos belly up.

I'll keep those links though there very useful indeed. Thanks Arvin.

Regards,
- BackAccess

: Typically, databases start with tables then move to queries before any
code
: is written. I'm not sure why you started by writing code, but I'll leave
: that for another post.
:
: 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
:
: : >
: > Hello NewsGroup,
: >
: > I've been constructing an application UI using Access 2003. I've just
: > started it early this morning so it hasn't been backed up as yet. There
: are
: > no tables, queries, forms or report (didn't quite get to that stage).
: There
: > are 10 class modules and 5 modules only. While coding away I got an
error
: > message, and Access had to restart, or gave me the option after the
crash.
: >
: > Now when I try to open any of the module sheets I get the following
: > disastrous message;
: >
: > "MS Office Access has detected corruption in this file. Try to repair
the
: > corruption, first make a backup copy of the file. Then, on the tools
: menu,
: > point to the Database Utilities and click Compact and Repair Database.
If
: > you are trying to repair the corruption then you will need to recreate
the
: > file or restore it from a previous backup."
: >
: > | OK | Help |
: >
: > Well didn't quite get to the end of a working day to back up the
database.
: I
: > can't create another database and either import into it or export from
the
: > database to the new one cause I get the same error message. Can't export
: the
: > module sheets otherwise I get the above error message.
: >
: > Is there anything I can do to retrieve the module files? Any kind of Hex
: > file viewer or something as such I can retrieve the contents of the
: modules
: > file. My lessons have been learnt!!!!
: >
: > Thank you all NewsGroup.
: >
: > - BackAccess (I truly have been back accessed this time)
: >
: >
:
:

 

[Tony Toews]

I even found what ruined the entire
database, make sure if you're ever doing the same to return a valid value
for your "hook procedures" and API function parameters, otherwise Access
just geos belly up.

Ayup, Access can get confused easily on slightly flaky API calls.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm