Doug Murphy
dw-murphy at cox.net
Thu Jan 14 13:32:29 CST 2010
John, As far as I can tell the file does not open. If it does it opens and closes so fast that you can't see it or the lock file. AS to Max's suggestion I can't open the file so I can't set any of the startup properties. I have a utility that sets these from another database and did set all the properties to let the file open and show menus. Didn't help. As to Access opening the file when it compacts I am not sure that is what happens. If you watch during compact another file is created, then I suspect something like copy all objects happens into this file, the original file is deleted and then the new file is renamed. There is a know problem with Access 2007 not creating the temp file, but deleting the original file. I think this was corrected with one of the original service packs. Thank you for your thoughts. Doug -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Thursday, January 14, 2010 5:22 AM To: Access Developers discussion and problem solving Subject: Re: [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. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com