Seem .mdb has problem, Help please.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

(I use WinXP Pro,AccessXP, JET SP8, ADO 2.8)

I edited some part of my programs but not relate to any data processing
part. It causes my program hang ("Microsoft Access has encountered a problem
and needs to close" message). After that I found the problem line BUT seem
this line is changed if I edit/add some other codes. One time, I added
DoEvents 10 lines before the problem line. Hang is gone. Then I tried by
comment line by line. It not hang until all DoEvents are comments. Then I
removed all 10 comments and tried again. This time it still hang. It seems
problem line was changed to somewhere else !!! Another strange is , one time,
after code exit from sub procedure, next executing line is not the suceeding
line in calling program but skip 2-3 lines. Then I think Access may confuse
between source code and intermediate compiled code (eventhough I recompile
it) !!!

I have tried recompile, shutdown-restart windows, delete .ldb everytime it
hang, import all objects to new .mdb except problem form, I have even tried
create the new form and paste only code from old .mdb. All can not solve
problem. I'm afraid problem may spread to other forms. Please help and Do you
know where compiled code is kept ?
 
Allen Brown, if you read this, I decompile my code as you replied to other
post by using command line like "c:\Program Files\Microsoft
ffice\office10\msaccess.exe" /decompile "c:\MyPath\MyDatabase.mdb". But
Access compiled very quickly. My program contain many of forms and a lot of
code. So, I think it does not decompile all code, Possible ? Have any method
to clear last compiled code ?

TIA
 
Allen Brown, if you read this, I decompile my code as you replied to other
post by using command line like "c:\Program Files\Microsoft
ffice\office10\msaccess.exe" /decompile "c:\MyPath\MyDatabase.mdb". But
Access compiled very quickly. My program contain many of forms and a lot of
code. So, I think it does not decompile all code, Possible ? Have any method
to clear last compiled code ?
Click to expand...

I've got an (almost too big) database - with many thousand lines of
code - and it decompiles in one or two seconds. The decompile process
doesn't actually remove anything; it just sets some flags internally.
Compilation is very fast as well (a couple of seconds). I think you're
fine.

Be sure to Compact after decompiling; then compile; then compact
again. The Compaction will be the slowest step.

John W. Vinson[MVP]
 
Back
Top