Access Database Won't Open - NO Error Messages

geekette

Board Regular
Joined
Sep 12, 2006
Messages
120
Hi,

We have been using an Access database at work with no problems at all....today we tried to open the database (the file is still showing exactly the same) on opening it opens Access but then nothing happens...there are no error messages to suggest anything it just simply does not open??

Does anyone have any advice on what we can do? I have tried a number of things to rectify it but whatever I try it acts like the file is not there (even though it shows it in windows explorer).

Any help would be so appreciated :O)
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,651
Office Version
365
Platform
Windows
Open up Access and create a blank database.

Goto File>Get external data>Import...

Locate the problem file and see if you can import the tables/reports etc.

If you can do so, then close the newly created database and see if that opens normally.

If it does then it could be the original file has become corrupted.

You might be able to repair it if you goto Tools>Database Utilities>Compact and repair... when you open Access on its own.
 

geekette

Board Regular
Joined
Sep 12, 2006
Messages
120
Hi - I've already tried both those options and on both it lets me navigate to the file but then when choose the file the prompt disappears and I'm back with an empty Access screen??
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,651
Office Version
365
Platform
Windows
What prompt are you referring to?
 

geekette

Board Regular
Joined
Sep 12, 2006
Messages
120
If I open MS Access and go to Tools > Database Utilities > Compact and Repair .... it lets me navigate to the file but when I choose the file nothing happens and I'm left with a blank access screen.

Likewise if I create a new blank database and go to File > Get External Data > Import Data it lets me navigate to the file but when I select it nothing happens again....?
 

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,670
Office Version
2013
Platform
Windows
I hesitate to say so but this sounds serious! Did you have any further luck? There are access recovery specialists you can find on the web - software and/or services. Try using another program to access the file too, if possible, besides your local access application. If/when you recover, be sure to run a thorough set of pc maintenance routines - full virus scan, check disk for errors, defragment, check for updates at Microsoft, and implement a backup strategy. Consider the age of your pc - disks don't last forever.
 

boblarson

MrExcel MVP
Joined
Nov 14, 2008
Messages
1,964
Have you tried rebooting your computer?
 

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,670
Office Version
2013
Platform
Windows
Thanks for the reality check Bob! That's always where I start...
 

gunwant

New Member
Joined
Jun 4, 2010
Messages
3
Hi,
Did you find a solution to this problem? I am having the same problem now. Cant find anything about it. It seems not many people have this problem. Its rare.

I have tried all the tricks mentioned above. None seem to work.
I need to know if there is a solution to this one.

:)
 

Watch MrExcel Video

Forum statistics

Threads
1,102,095
Messages
5,484,639
Members
407,459
Latest member
DICKSON KIMEMIA

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top