Solved

My file Access Database won't open

Posted on 2013-05-17
10
559 Views
Last Modified: 2013-05-17
Help!!! All of a sudden my access database won't open anymore, it says it is corrupt. What should I do?

Is there an autosaved file somewhere that is before it was corrupted?
0
Comment
Question by:cansevin
  • 6
  • 4
10 Comments
 
LVL 22

Expert Comment

by:Kelvin Sparks
Comment Utility
From Access without any database open try to compact and repair (long shot but may work). If you don't have an earlier copy (no, there's no auto recovery) make a new database and see if you can import your objects and data from the former database.

Kelvin
0
 

Author Comment

by:cansevin
Comment Utility
Compact and repair didn't work... this is really not good. I haven't made a copy in a week and there is a lot of data that has been entered on it.
0
 

Author Comment

by:cansevin
Comment Utility
When I open it, a box comes up saying it can find a form, when I hit OK it appears to be cycling through all the forms.
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
Comment Utility
What happens if you try and open the database while holding the shift key down until opening finished - does that take you to the database windows (where you see all tables, queries etc....)
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
Comment Utility
What version of Access are we using here?
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 

Author Comment

by:cansevin
Comment Utility
Access 2007
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
Comment Utility
Have you tried the import to another database - try importing the tables only in the first instance, then the queries
0
 

Author Comment

by:cansevin
Comment Utility
The shift button didn't work... how do I import the tables?
0
 
LVL 22

Accepted Solution

by:
Kelvin Sparks earned 500 total points
Comment Utility
From menus, click external data and follow your nose. Have to head out for a couple of hours.
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
Comment Utility
I trust in doing this all came right? It does highlight the need for regular backups or copies. Also "splitting" the database ( data in a back-end and the rest in a user frontend will reduce the possibility of loosing everything if a form or some VBA corrupts the container.

I'm glad it all worked out for you.

Kelvin
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now