Access Access97 MDB file corrupted

Joined
Nov 27, 2006
Messages
1
Reaction score
0
Hi,

I've created an mdb file on Access 97.

5 small table; 1 Form; 2 reports; and some VB


Description of problem

I wrote some VB script, that caused an error. [The VB script referred to a control that was named incorrectly.]

I fixed the VB, saved it.

I put the form in design mode, and renamed the control.


Turned the form into normal mode to view the data and * crash *... Accesss shut down.

Now I cannot open the file becuase Access closes as soon as the file is loaded.


More details

The mdb file opens, I can see the database window, and when it loads the "display form" [Tools > Statup > Display form] * crash *.

I have compressed the database... no effect.

I have repaired the database [successfully]... no effect

I have created an MBE file... and it runs perfectly! So this shows that the VB code was saved well and functions properly just like the controsls on the form are named correclty.

[Even if they were named incoreectly, why don't I just get an error msg?]


I Think....

I feel that if I could just open the file without anything running... I could resave the form and fix this issue.


How can I tell Access not to load the "display form"? or

How can I modify the mdb file not to load its "display form"? or

Stop the VB?

Any other suggestions?


Thanks for your time
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top