Max Wanadoo
max.wanadoo at gmail.com
Fri Jan 15 12:03:53 CST 2010
Does this mean anything or have any bearing on it? What does your Access-Special-Keys show? In a Microsoft Access file (Microsoft Access file: An Access database or Access project file. An Access database stores database objects and data in an .mdb file. A project file doesn't contain data and is used to connect to a Microsoft SQL Server database.), you can prevent the Microsoft Visual Basic Editor from starting when you press ALT+F1 and the Immediate window from showing when you press CTRL+G. On the Tools menu, click Startup. Clear or select the Use Access Special Keys check box. Note Changes to this setting in the Startup dialog box won't take effect until the next time the Access file is opened. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy Sent: 15 January 2010 17:48 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access 2007 database file won't open If you hit F11 you get a message that says no database is open. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Friday, January 15, 2010 9:38 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access 2007 database file won't open Yes, but if the application INSIDE the access window is dragged off below the visible window, it will "hide". Are there scroll bars anywhere? Do you have multiple Screens/monitors where it might be hiding on another monitor? Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy Sent: 15 January 2010 17:20 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access 2007 database file won't open Lambert, That isn't the problem. The application window is visible, the problem is the window is just Access, not the application that should be running in Access. It is like the file is just a short cut that opens Access. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Friday, January 15, 2010 6:20 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access 2007 database file won't open Did anyone already ask... Could it be that the application windows are all "off-screen"? Have you tried choosing 'Cascade' from the Window menu in Access? Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Friday, January 15, 2010 8: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. Tha! t 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 -- 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