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
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