[AccessD] Access 2007 database file won't open

Rocky Smolin rockysmolin at bchacc.com
Wed Jan 13 22:34:43 CST 2010


So you have a version that works on your box.  You send it to the client,
and the problem recurs there?  With startling regularity?

And then if they send you their hosed copy, is it still hosed on your
machine but can all be recovered by importing the objects again?

R

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
Sent: Wednesday, January 13, 2010 8:22 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2007 database file won't open

Hi Rocky,

Both Daryll and I were able to import all objects to a new db. That opens on
the local machine. I am just trying to figure out what is different about
the file after the client works with it. Have tried this on 3 different
computers with Access 2007 on them and they all behave the same, i.e., the
file just opens access, but not the database. The client is on a local
network and all their computers can open this file as it should be. There is
something about their installation or service pack level that is doing this.
They all run Windows XP. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Wednesday, January 13, 2010 3:54 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2007 database file won't open

Doug:

Have you tried creating a new, empty db and file-->get external
data-->import thing to see if anything shows up in the objects window?

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
Sent: Wednesday, January 13, 2010 3:29 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2007 database file won't open

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.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Collins, Darryl
Sent: Wednesday, January 13, 2010 3:24 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access 2007 database file won't open



"If you open access and then open that database from Access it does the same
thing?"

I would suggest you try this as well. I have had numerous instances in
A2003 where you double click on the icon and nothing happens, but if you
open Access and then the database file via "File > Open" it will open up
normally and behave as expected.

Not sure if it has anything to do with your A2007 issue.  Worth a try
though...

Cheers
Darryl. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
Sent: Thursday, 14 January 2010 10:18 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

"This e-mail and any attachments to it (the "Communication") is, unless
otherwise stated, confidential,  may contain copyright material and is for
the use only of the intended recipient. If you receive the Communication in
error, please notify the sender immediately by return e-mail, delete the
Communication and the return e-mail, and do not read, copy, retransmit or
otherwise deal with it. Any views expressed in the Communication are those
of the individual sender only, unless expressly stated to be those of
Australia and New Zealand Banking Group Limited ABN 11 005 357 522, or any
of its related entities including ANZ National Bank Limited (together
"ANZ"). ANZ does not accept liability in connection with the integrity of or
errors in the Communication, computer virus, data corruption, interference
or delay arising from or in respect of the Communication."

--
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

--
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




More information about the AccessD mailing list