Database error while working on secure database 2

[netrusher]

I have a secure database. I was changing some code, etc and received an error stating:

Microsoft Office Access has encountered a problem and needs to close. We are sorry for the inconvenience.

The Repair my open database and restart Microsoft Office Access checkbox is checked.

I trys to repair and create a backup but the same thing keeps happening over and over. I can open
the database and all forms, queries, tables, etc. etc. by holding the shift key down when opening this
secure database but I cannot without holding the shift key. Can anyone give me any suggestions as
to how to fix this. This is a real nuisance and I need HELP!!

 

[Remou]

Things to do.
1. Check the code that is running on opening the database, and any forms that are loaded.
2. Decompile.
3. Import everything into a fresh database, possibly avoiding the damaged form(s) (see 1)

 

[netrusher]

Remou:

I am trying to decompile but keep getting "you do not
have necessary permissions". This is a secure database, is
there something else I must do to be able to ope the
database using the decompile switch?

"C:\Program Files\Microsoft Office\Office11\msaccess.exe" "C:\my documents\newdatabase\BereaECN.mdb" /decompile

 

[netrusher]

Remou,

How can I import objects into a new database when the original
database is secure?

 

[PHV]

How do you normally open the secure database ?
If via a shortcut then post the content of the target property.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[netrusher]

PHV,

Here it is!

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "c:\my documents\working\bereaecn.mdb" /wrkgrp "s:\everyone\ecndatabase\ecndatabase.mdw"

 

[PHV]

So, try this:
"C:\Program Files\Microsoft Office\Office11\msaccess.exe" "C:\my documents\newdatabase\BereaECN.mdb"/wrkgrp "s:\everyone\ecndatabase\ecndatabase.mdw" /decompile

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[netrusher]

Thanks PHV,

Once I run this does it automatically decompile the database?