VBA Editor not starting correctly

[johnwind]

Hello All,

I hope someone out there has some input on this problem, it driving me
nuts.

This problem only occurs with one code .mdb out of many I have on my
system, which implies the problem is with the .mdb, not the
environment.

I'm using Office 2K developer edition, Win2k O/S. Office and O/S are up
to date on service packs and patches. Here is the issue:

1. I open the code .mdb using the shift key to bypass the startup
program.

2. The Access environment opens normally with the main window open and
forms object selected.

3. When I use the code button to open the editor, the default selected
form opens in the design mode not the editor. (Normally the editor
opens at this point)

4. When I select the code button at this point the editor opens, but
the editor is all messed up. The code modules are open on a dark gray
window. Several of the module window headers (the part with the general
and declaration drop down boxes) are behind the main tool bars and I
cannot grab them to move them. The project explorer, property window
and immediate window are gone and will not open (or at less if they are
opening they do not appear)

5. At this point nothing I do fixes the problem. I've tried
compiling, compact/repair, used jet compact utility and many other
sequences of opening, saving and closing.

6. I have noticed that when I close the .mdb in this condition, the
associated lock file does not close.

Now for the rest of the story

7. If I delete the lock file, reopen the .mdb and immediately
"Compact and Repair Database" everything works fine. When I close
the .mdb in this condition the lock file closes fine.

8. When I reopen the mdb without compacting and repairing its back to
square one. I've tried many sequences of saving and closing.

My only guess is something is hosed up with the docking in the editor
window. This is a very large project. I do not want to copy everything
one by one to a new .mdb
Thanks,
John Wind

[Rog]

John,

"Copying everything" is not such a big hassle as you may think.
Create a new database and use the File/Get external data /Import
function. Just click on "select all" in each of the tabs (tables,
queries, etc.)
This may solve your problem.

[David LACASSAGNE]

Sometimes I also have similar problems.

I have a solution that has worked each time for me, and that avoids to
copy all in another mdb file:

Lauch the database using the /decompile flag ("C:\Program
Files\Microsoft Office\Office\Msaccess.exe" /decompile toto.mdb)

Normally the problem should be solved. You can then compile your
project and compact the database.

David.
jo******@mindspring.com wrote in message news:<11**********************@g14g2000cwa.googleg roups.com>...

Hello All,

I hope someone out there has some input on this problem, it driving me
nuts.

This problem only occurs with one code .mdb out of many I have on my
system, which implies the problem is with the .mdb, not the
environment.

I'm using Office 2K developer edition, Win2k O/S. Office and O/S are up
to date on service packs and patches. Here is the issue:

1. I open the code .mdb using the shift key to bypass the startup
program.

2. The Access environment opens normally with the main window open and
forms object selected.

3. When I use the code button to open the editor, the default selected
form opens in the design mode not the editor. (Normally the editor
opens at this point)

4. When I select the code button at this point the editor opens, but
the editor is all messed up. The code modules are open on a dark gray
window. Several of the module window headers (the part with the general
and declaration drop down boxes) are behind the main tool bars and I
cannot grab them to move them. The project explorer, property window
and immediate window are gone and will not open (or at less if they are
opening they do not appear)

5. At this point nothing I do fixes the problem. I've tried
compiling, compact/repair, used jet compact utility and many other
sequences of opening, saving and closing.

6. I have noticed that when I close the .mdb in this condition, the
associated lock file does not close.

Now for the rest of the story

7. If I delete the lock file, reopen the .mdb and immediately
"Compact and Repair Database" everything works fine. When I close
the .mdb in this condition the lock file closes fine.

8. When I reopen the mdb without compacting and repairing its back to
square one. I've tried many sequences of saving and closing.

My only guess is something is hosed up with the docking in the editor
window. This is a very large project. I do not want to copy everything
one by one to a new .mdb
Thanks,
John Wind

[johnwind]

Rog wrote:

John,

"Copying everything" is not such a big hassle as you may think.
Create a new database and use the File/Get external data /Import
function. Just click on "select all" in each of the tabs (tables,
queries, etc.)
This may solve your problem.

Rog,

Thanks for the advice, copied everything to new mdb and fixed the
problem.

Typical case of not seeing the forest for the trees. I sometimes get
too focused on the why and not the fix.

[johnwind]

Thanks David,

I'll make a note of this in case it happens again?