Tough one - really messed up database

[dkintheuk]

Hi all,

I have a database with all the usual good things in it, except that it
is way corrupt.

I can open it apparently and look at tables, vewi designs of queries
etc but as soon as I click on a module, i get a message that the
module isn't there or the name is mis-spelled.

Now I tried to find a help company out there to get this back in one
piece but obviously before I pay out cash can anyone else help?

The online company that has looked at the MDB has told me that they
can recover it and all code. To be honest I already have all the data
so the code is kinda what I want.

I tried a hex editor on a copy of the MDB but can't read the output
then I got told that the decompile switch might help make it
readable... no joy.

Can anyone advise how these companies do this work? It can't be that
hard... can it???

If anyone wants a copy of the database to try and recover things then
please let me know...

Cheers,

Rob.

[Roger]

On Jun 13, 4:00*am, dkintheuk <[e-mail]:

Hi all,

I have a database with all the usual good things in it, except that it
is way corrupt.

I can open it apparently and look at tables, vewi designs of queries
etc but as soon as I click on a module, i get a message that the
module isn't there or the name is mis-spelled.

Now I tried to find a help company out there to get this back in one
piece but obviously before I pay out cash can anyone else help?

The online company that has looked at the MDB has told me that they
can recover it and all code. To be honest I already have all the data
so the code is kinda what I want.

I tried a hex editor on a copy of the MDB but can't read the output
then I got told that the decompile switch might help make it
readable... no joy.

Can anyone advise how these companies do this work? It can't be that
hard... can it???

If anyone wants a copy of the database to try and recover things then
please let me know...

Cheers,

Rob.

have you tried creating a new mdb and importing the tables, queries,
forms, reports, modules into it ?

[dkintheuk]

On 13 Jun, 11:21, Roger <[e-mail]:

On Jun 13, 4:00*am, dkintheuk <[e-mail]:

Hi all,

I have a database with all the usual good things in it, except that it
is way corrupt.

I can open it apparently and look at tables, vewi designs of queries
etc but as soon as I click on a module, i get a message that the
module isn't there or the name is mis-spelled.

Now I tried to find a help company out there to get this back in one
piece but obviously before I pay out cash can anyone else help?

The online company that has looked at the MDB has told me that they
can recover it and all code. To be honest I already have all the data
so the code is kinda what I want.

I tried a hex editor on a copy of the MDB but can't read the output
then I got told that the decompile switch might help make it
readable... no joy.

Can anyone advise how these companies do this work? It can't be that
hard... can it???

If anyone wants a copy of the database to try and recover things then
please let me know...

Cheers,

Rob.

have you tried creating a new mdb and importing the tables, queries,
forms, reports, modules into it ?- Hide quoted text -

- Show quoted text -

I show have mentioned... I have already tried that and got FAIL.

[dkintheuk]

On 13 Jun, 11:39, dkintheuk <[e-mail]:

On 13 Jun, 11:21, Roger <[e-mail]:

On Jun 13, 4:00*am, dkintheuk <[e-mail]:

Hi all,

I have a database with all the usual good things in it, except that it
is way corrupt.

I can open it apparently and look at tables, vewi designs of queries
etc but as soon as I click on a module, i get a message that the
module isn't there or the name is mis-spelled.

Now I tried to find a help company out there to get this back in one
piece but obviously before I pay out cash can anyone else help?

The online company that has looked at the MDB has told me that they
can recover it and all code. To be honest I already have all the data
so the code is kinda what I want.

I tried a hex editor on a copy of the MDB but can't read the output
then I got told that the decompile switch might help make it
readable... no joy.

Can anyone advise how these companies do this work? It can't be that
hard... can it???

If anyone wants a copy of the database to try and recover things then
please let me know...

Cheers,

Rob.

have you tried creating a new mdb and importing the tables, queries,
forms, reports, modules into it ?- Hide quoted text -

- Show quoted text -

I show have mentioned... I have already tried that and got FAIL.- Hide quoted text -

- Show quoted text -

I have found this discussion...
http://groups.google.co.uk/group/com...a96f4da08aa1bc

... which appears to state that the VBA code is stored in a system
table.

Can someone tell me which table and I will delve...

Plus keep up with the ideas...

[Chris O'C via AccessMonster.com]

It's in the MSysAccessStorage system table in Access 2002-2003 db format.

It's so easy to recover corrupted VBA code from the system table that if you
work all weekend, you could recover it even before Christmas. Maybe around
Halloween if you get some help.

If you don't want to pay for recovery services, remember to back up important
files before you need them.

Chris
Microsoft MVP
dkintheuk wrote:

Hi all,

[quoted text clipped - 34 lines]

>>
- Show quoted text -

I have found this discussion...
http://groups.google.co.uk/group/com...a96f4da08aa1bc

... which appears to state that the VBA code is stored in a system
table.

Can someone tell me which table and I will delve...

Plus keep up with the ideas...

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200806/1