Rocky Smolin
rockysmolin at bchacc.com
Thu Jan 14 19:01:49 CST 2010
Per your post you're only minutes way... R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy Sent: Thursday, January 14, 2010 4:42 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access 2007 database file won't open Hello Gary, # Cocktail >5 = true is where I'd like to be right now. Those are all good thoughts and when I get the current tasks behind me I'll try some of your ideas. Right now I am working with the exported DB to get back on track work wise. When I put it back on their system I'll open and close, compact etc and make a copy to check. Doug -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos Sent: Thursday, January 14, 2010 4:30 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access 2007 database file won't open What if you made your fresh file on your system and then took that to client, opened and then closed but did nothing else. Then did a file compare somehow bit by bit. Do we know what the structure of an Access 2007 file is? Probably not. There used to be a file compare utility in DOS wasn't there? I know of editors that will do that. Slickedit comes to mind. Is the problem unique to that database? If you make a new database with entirely different contents does it do the same thing?. How about if THEY make a database on their end that you have never seen on your end, does that have the same issue? I would try a few different databases - one with just a table. ANother with a query and table, Anotehr with a form too. Another with a report in addition. Try and narrow it down to a specific type of object or something? Just some thoughts after a cocktail. ;-) GK On Thu, Jan 14, 2010 at 1:32 PM, Doug Murphy <dw-murphy at cox.net> wrote: > 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 > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Gary Kjos garykjos at gmail.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com