Error! "file needs to be repaired or isn't a database file"

[johnyjassi]

Hi Experts,
Hope any of guys can help me here. I got the above error while opening my application, and .idb of the file is even there. I am sure nobody is using this app. What could be the cause and any solution. Any help will be appreciated.

Thanks!

 

[CyberLynx]

Sounds like the Database file is corrupt (hope you have a backup). Could also be that you have a serious issue with one (or more) of the Forms within the Database.

Try opening the Database while holding down the Shift key so as to display the Database Window. Go into the Forms section. From the top of the list, open each Form in Design View and then try to access the Code module for that Form. If Access crashes, then you have found the problem Form.

Sometimes this doesn't help either....you can have the same issue with any Form if you try to open it in Design View. The best you may be able to do is try the Compact and Repair feature or, if you can access a database code module, you may be able to salvage your Code.

.

 

[boblarson]

that is LDB file, not IDB file. Also, if you don't have the database open but the LDB file is still there, try deleting the LDB file before trying to open the MDB file.