DB Corruption or someother issue!

[Bosch]

Hi all..

In my access 2003 application, I can open the database and goto the design view of the Forms..but I cannot view the code. I tried both Alt+F11 and Right click on the form and "Build Even" and "Code Builder".

In both cases, access application stops responding. Then I have to close it using the task manager.

Any ideas how to fix this issue? Thanks in advance for your help.

 

[Matt Greatorex]

I've had exactly the same problem. In my case, it was a corrupt Db.

Luckily, I was able to fix it by creating a new, blank Db and importing everything from the old one.

Failing that, this may help

http://allenbrowne.com/ser-47.html

 

[Bosch]

Thanks Matt..
I tried all that was mentioned in the link but nothing worked.
But I could isolate the problem to a single Form..Even this form I could open in the Design view..but unable to view the code. Looks like I will have to redo this form(Luckily I have a backup about 10 days old..so I will have to redo whatever I changed in the last 10 days)..

If you have any other ideas please let me know.

Thanks again.

 

[DataNumen]

Hi Bosch,

Your database was corrupt. You can try our product Advanced Access Repair to repair your Access database. It is a powerful tool to recover data from corrupt or damaged Microsoft Access databases which supports to repair Microsoft Access 95, 97, 2000, XP and 2003 databases.

Please visit http://www.datanumen.com/aar/index.htm for detailed information about Advanced Access Repair.

And you can also download a free demo version at http://www.datanumen.com/aar/aar.exe

Alan Chen
DataNumen, Inc. - World leader in data recovery technologies
Website: http://www.datanumen.com
Fax: +1-800-9917-FAX (US Toll-Free), +852-31829286 (HONG KONG)