[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