[AccessD] Access 2007 database file won't open

 >The interesting thing is that I can compact it from Access.

What does this mean?  If you are literally opening the file (even though you don't see it) and then 
compact it and the compact works then the file is in fact opening.

Check whether the lock file is created and stays open.  If so then you have in fact opened the FE 
and you are just not able to see the database window.  If the LDB file is never created then you 
haven't in fact opened the file.  If the LDB is created and immediately closes again, then you have 
in fact opened the file, and then the file is shutting back down again.

Check the database startup properties dialog (Tools / Startup in A2K and previous) to look at the 
check boxes for how the database starts up.  Maybe something there is screwy.

John W. Colby
www.ColbyConsulting.com


Doug Murphy wrote:
> Thanks Darryl,
> 
> Doesn't work that way either. The interesting thing is that I can compact it
> from Access. I can also decompile from the command line . This behavior
> doesn't make sense to me.