[AccessD] Access 2007 database file won't open

Maybe try opening it with the shift key down?  If you open access and
then open that database from Access it does the same thing?

Not much help I know. I don't use 2007 at work. I have it at home is
my only exposure.

GK

On Wed, Jan 13, 2010 at 5:05 PM, Doug Murphy <dw-murphy at cox.net> wrote:
> Folks,
>
> Not much feedback on this.
>
> David offered to see if he had the same experience I did so I sent him the
> front end accdb file. He couldn't get it to open either. He also could
> import all the objects into the new database. Today I visited the clients
> office to look at their system. They are running Access 2007 SP2 just like I
> am. The file opens fine on their system. I decompiled on their computer and
> compacted then copied it to a flash drive and brought it back to my office.
> On my system it still will not open. All the happens when you open the file
> is that Access starts, but the DB does not open. Same behavior as before.
> This is very puzzling and I can find no info on Google with any of the
> searches I tried. Also tried Expert's Exchange but no explanations there
> either.
>
> Any thoughts?
>
> Doug
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
> Sent: Monday, January 11, 2010 3:58 PM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Access 2007 database file won't open
>
> Folks,
>
> I have a weird one, seems like all I get. We developed a database app for a
> client in Access 2007. The file is in the accdb format. All was well and we
> were doing upgrades as the client needs them. Today I got the front end file
> back from them and it would not open on my computer. There is no error
> message, Access just opens as it would if you opened it from the program
> menu. I checked to make sure the database window, or what ever you call it
> in A2007, wasn't hidden and I got a message that there was no file opened,
> which is what it looks like. Did all the normal stuff, like get another copy
> of the file, compact repair, decompile, with no results. The file did
> compact as it got smaller and it looks like it decompiled but after the
> action I got the Access program window, i.e. no open database. I had the
> client compact the file on their computer and resend. Still the same
> non-result. Then I created a blank DB and imported all objects from the file
> that won't open into it. That worked.
>
> I tried this file on two of our computers with 2007 and got the same
> behavior. Has anyone seen this before? Could it be a service pack thing? I
> looked on Google and couldn't find any posts about this. I need to figure
> out what is going on as I don't want to have to do this every time we move
> files around with this client and I have spent a couple of hours messing
> with this.
>
> Any suggestions would be appreciated.
>
> Thanks in advance.
>
> Doug
>
> --
> 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