Missing modules

[Guest]

Hello,

Today i tried to run an access program and realized that all modules and
references are missing!
I checked also my backup (two weeks old) and the happens also to this copy.
It's a .mdb file and thousands lines of code written there.
I can't explain it, all modules are there but when trying to edit, access
says that cannot find it!

Any ideas?

John

 

[Michel Walsh]

Hi,



A little bit late, but just in case...


Check if the read only flag (from the file system) is not set on the file
you open. That *may* happen if you ever copy the file on a CD write once, or
something similar.



Hoping it may help,
Vanderghast, Access MVP

 

[Guest]

Thanks for your reply.
This is not the case... This Aceess program is in my hard disk. I'm using it
once a month to produce a monthly report for my HQ. One day that i tried to
run the report, when pressing buttons nothing was happening. I checked all
modules where there but i could not edit them, because they where missing.
Fortunately i restored it from a working backup.

The only thing that changed and make me suspicious, is the SyncToy from
PowerToys, that i used it to copy the file to my backup location, but I used
it also for many other access databases that are working perfect.

You know, i'm an experienced developer in Access (and not only...), but this
is another one good reason not to take it seriously as a developing
'platform'.

Anyway, i have this mdb file, as a sample in my archive and I can send it to
anyone who wants it for inestigation.

 

[TC]

You know, i'm an experienced developer in Access (and not only...), but this
is another one good reason not to take it seriously as a developing
'platform'.

That is just absolute nonsense. You are clearly /NOT/ an experienced
developer, or you would have some clue why your modules have allegedly
"disappeared".

I've been using Access for many years. I've written hundreds of
thousands of lines of code in it. I 've never had a module "disappear".
Nor would I ever expect to.

Where is your evidence that this is a fault in Access, and not an error
on your part?

TC

 

[Michel Walsh]

Hi,


If you use Access 2000 or later, all the Access "objects" are supposed to
be stored in just one large blob. If corruption is involved, probably the
forms would have been lost too, since part of the *same* blob.


If you see the modules but cannot edit them, I would rather suspect
something is incompatible, or that the registry has been corrupted. A
possible case is a MDAC installation that turns wrong (incomplete), but that
would mean you could read the modules if the mdb file is on another PC, on
that other PC.

Can you run a public method, in a standard module, in the immediate window?
can you import the modules in a new db? have you killed the ldb file (it
may be that last time you modified one of the module, your exit didn't
execute well and Access still lock you out) before opening the application?
(do it ONLY if you are sure no one is using the application) Finally, if
none of the above solved your case, have your tried the decompile switch?



Hoping it may help,
Vanderghast, Access MVP

 

[TC]

If his database has been corrupted, then clearly, everything within it
(data & code) could become unusuable. But I object to his implication
that this is common with Access & makes it unsuitable as a development
platform. I'm sure you'd agree, no?

Cheers,
TC

 

[Guest]

Hello TC,

Sorry if I 'hurt' Access, saying that is not a serious developing platform.
You know, i have written thousand lines of code in Access, building many
applications with references to my own libraries, objects etc, spending the
80% of my developing time with this tool.

I've seen some non stable things in my many years experience and this really
hurt me, because the application that happened is the most serious for me and
the company that i work for.

I'm still writing and will most of my applications in Access, I know the
advantages and disadvantages of it, and ... sorry for my bad English.

Sometimes when talking to a foreign language, many things may sound tougher
than what you really mean.

Anyway, I still have this file, tryed almost everything and could not find
an answer.
The data is there, all modules are there (the icons and their names...), all
forms are there with no class modules behind them etc.
When trying to call a public function in the imediate window say 'sub or
function not defined'.

Thanks god that I found a working backup, otherwise more than two months
hard devloping time whould be blowed up!

See ya

Ο χÏήστης "TC" έγγÏαψε:

 

[TC]

Hi John

Sorry if I was a bit blunt

Have you tried a decompile? Create a shortcut of the following form,
run it, & see if this fixes it:

(all on one line)

"full path to MSACCESS.EXE"
/decompile
"full path to your database"

Whatever you do, /do not/ use your original copy of the (bad) database!
Take a copy, and work on that instead Then, if you make it worse, you
can always go back to the original copy.

If nothing else works, you could send the database to a data recovery
service - they can often fix it. But you say you have a backup, so
maybe you don't need to do that.

Good luck & Merry Xmas,
TC

 

[Guest]

Hello TC,

I will try 1-2 more things on that, just for curiosity.
The real message that comes out from this story, is how important is a
backup and the most important task is the restore.
We have to test often the restore procedure, just to be sure that if
sometime we need it, it's there and we can count on it.

Well, thanks for your advices, always need a second opinion and if I found
the answer I'll post it here.

Merry Xmas
John

Ο χÏήστης "TC" έγγÏαψε: