help my database doesn't open

D

Database User

When i try to open my database it said :

The last time you opened it it created a sever error do you want to contine

I say yes and then it says

THe database needs to be repaired or isn't a database file - do you want to
repair it
I say yes, it begins repairing it and then crashes and says

Access has encountered a problem and needs to close

I'm in desparate need of help - can anyone answer??

I tried creating a new database and importing the info but it gives me the
same messages
 
R

Roger Carlson

My experience is that if it crashes during a repair it usually cannot be
repaired again. Here are a couple of resources for database corruption:

http://www.rogersaccesslibrary.com/jerrywhittle/FixCorruptAccessDatabasev42.doc
http://www.granite.ab.ca/access/corruptmdbs.htm

If nothing works, you might be able to retrieve at least part of your
application and/or data from a repair service. Here is a link to other
Emergency Links:
http://www.rogersaccesslibrary.com/linksemergency.html

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
D

Database User

maybe there's some connection to the .ldb file that keeps appearing even when
i delete it even though no other user is on the database?
 
F

FinRazel

I don't know why your database is crashing but if you are trying to recreate
your database...

Are you trying to import Excel files using Access? If so, try using Open
instead of Import.

Is this a network-wide problem? To test, try recreating or opening the
database while logged in as a different user.

As for that, "isn't a database file" part of the error message...
If you need to modify file extensions, you can do so by going into My
Computer>Tooks>Folder Options -> View Tab
and uncheck the "Hide File Extensions for Known File Types" box.
 
D

Database User

We managed somehow to restore the tables and i have an old backup of the form
and report design so what i did was i imported all queries, forms, reports
and macros into this database which just had the tables. Everything looks
okay but then i have a form and a subform and i'm unable to edit anything in
the form or subform what could be my problem?
 
F

FinRazel

1. Check the properties of all of the files from which you are building this
database. Is there anything listed as "read-only" that should be writable?
If so, modify.

2. If the forms aren't too complicated, try rebuilding them instead of
importing them. Building a dummy form within THIS instance of your database
and seeing if it works could be a valuable troubleshooting excercise. It
could help to figure out where the problem is.
 
Top