[AccessD] Access 2007 database file won't open

Jim Lawrence accessd at shaw.ca
Mon Jan 18 00:26:10 CST 2010


Hi Doug:

It does appear to be a non destructive error so it is not serious. The
system just stopping with no prompt is confusing. If in the interim, I do
run across a solution I will definitely post it.

Jim



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

Hi Jim,

I tried to see what was going on using Process Monitor, but couldn't see
anything specific that was failing. Let me know if you find out anything.
When I get time I am goig to pursue this a little more to see if there is a
bug somewhere or a problem with different dlls on different systems, kind of
like the vb6.dll problem with Access 2000. The good thing is this does not
appear to corupt the file away like that did. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Friday, January 15, 2010 5:01 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2007 database file won't open

There are no errors... it just stops working. The system doesn't freeze or
does the CPU or memory usage go off the scale. What the issue could be I
have no idea at this point. If there was at least an error response the
problem could be tracked.

I will be working on monitoring the actual program to see at what exe or dll
the Access2007 actually fails but that will have to wait.

Fortunately the client had an Office2003 version and we could quickly move
back...

Jim
 

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

Interesting. How do you tell the database is locked, or is that just a term
for nonresponsive? 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Thursday, January 14, 2010 2:09 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2007 database file won't open

I also have a similar situation at a client's site. Locking application but
no errors... Very strange indeed. We are moving back to Access 2003 until a
solution is presented or found.

Jim



-----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:06 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2007 database file won't open

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

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