Access Database Won't Open - NO Error Messages

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,670
Office Version
2013
Platform
Windows
Can you create a new database and try importing your tables, forms, etc. into it from the original?
 

gunwant

New Member
Joined
Jun 4, 2010
Messages
3
I tried that. I am able to navigate to the database. But when I click on it, nothing happens.
 

ehobbs

New Member
Joined
Jun 24, 2010
Messages
1
I have had the same issue. I could not open ANY mdb, but I could create and open a new one. Once I close the program and restarted and tried to open the brand new mdb, it would not open and gave the same symptoms as before. I copied the original suspect mdb over to another pc and it opened with no issues. My conclussion is that it is the software and this was caused after a windows update. Im going to restore and see if that corrects before I reinstall access 03.
 

OriginalSin

New Member
Joined
Jul 4, 2012
Messages
1
I Think I found a solution to this problem, but it will depend on what version you are using, when this happened to me I was using MSO 2003, anyway here's what I did to fix this problem.

- Copy the MSO2003 db to a Computer with MSO2010 Installed.
- Open the MSO2003 db (using shift) in MSO 2010
(if this is going to work, you should see your db tables now, if not sorry)
- This step depends on if you have a automatic startup form you run, if so, go to File > Options > Current Database Tab > Display Form (set this to none) and press OK
- Exit MSO2010
- Copy the db to a Computer using MSO2003 and Open the db (using shift)
- Convert the db to Access 2000 Format (rename it), hold shift until the compact is complete.
- Open the renamed 2000 db, Compact & Repair using shift to make sure things are working (you can continue without the C&R)
- Convert the 2000 db to Access 2003 Format (rename it again), use shift.
- Open the renamed db and you should be Good!

NOTE: renaming the db during the conversion is not necessary but it keeps each step so you can retrace your efforts if something goes wrong.

Hope this helps.
 
Last edited by a moderator:

Nvablejrg

New Member
Joined
Sep 10, 2008
Messages
21
I Think I found a solution to this problem, but it will depend on what version you are using, when this happened to me I was using MSO 2003, anyway here's what I did to fix this problem.

- Copy the MSO2003 db to a Computer with MSO2010 Installed.
- Open the MSO2003 db (using shift) in MSO 2010
(if this is going to work, you should see your db tables now, if not sorry)
- This step depends on if you have a automatic startup form you run, if so, go to File > Options > Current Database Tab > Display Form (set this to none) and press OK
- Exit MSO2010
- Copy the db to a Computer using MSO2003 and Open the db (using shift)
- Convert the db to Access 2000 Format (rename it), hold shift until the compact is complete.
- Open the renamed 2000 db, Compact & Repair using shift to make sure things are working (you can continue without the C&R)
- Convert the 2000 db to Access 2003 Format (rename it again), use shift.
- Open the renamed db and you should be Good!

NOTE: renaming the db during the conversion is not necessary but it keeps each step so you can retrace your efforts if something goes wrong.

Hope this helps.
Never had to do the above to get mine to work.

I am no guru by any means but I have had a similar problem and I figured if it works for Outlook it can work for Access.

I went to CTRL-ALT-DELETE and INDWOWS TASK MANAGER. I found that even though Access was closed the PROCESSES TAB still had MSACCESS.EXE running. I clicked "End Process" While in TASK MANAGER click the SERICES and end any processes that pertain to Access. Once I closed those out I was able to open Access.

Just found this and want to contribute.:LOL:
 

GregTheSquarePeg

New Member
Joined
Jun 24, 2013
Messages
8
Never had to do the above to get mine to work.

I am no guru by any means but I have had a similar problem and I figured if it works for Outlook it can work for Access.

I went to CTRL-ALT-DELETE and INDWOWS TASK MANAGER. I found that even though Access was closed the PROCESSES TAB still had MSACCESS.EXE running. I clicked "End Process" While in TASK MANAGER click the SERICES and end any processes that pertain to Access. Once I closed those out I was able to open Access.

Just found this and want to contribute.:LOL:
Thanks Nvablejrg! That worked a treat for me :eek:)
 

Watch MrExcel Video

Forum statistics

Threads
1,102,369
Messages
5,486,448
Members
407,547
Latest member
Sankarasrinivas

This Week's Hot Topics

Top