Access closes when i click on "forms"

J

Joao

Okay, here is an interesting problem:

I have a database I just created a couple of days ago in Access 2003.
Everything was working fine until now, but all of a sudden whenever I
click on the "forms" tab (no need to open any actual form, just click on
the tab), access just closes down. I tried compact and repair, but no
luck. I tried converting the database to access 97, and still no luck.
Any suggestions?
 
V

Vaibhav Joshi

My problem goes a bit beyond yours. For me the form opens ok but it suddenly
closes Access Entirely if I click "Design Button" or even many times when I
click certain command button on the form. This too would be fine but in the
process of closing it does not save the last design changes to to the form.
And the last changes to the records to are lost. Some body please help
.........

-Vaibhav Joshi
 
G

Gijs Beukenoot

From Vaibhav Joshi :
My problem goes a bit beyond yours. For me the form opens ok but it suddenly
closes Access Entirely if I click "Design Button" or even many times when I
click certain command button on the form. This too would be fine but in the
process of closing it does not save the last design changes to to the form.
And the last changes to the records to are lost. Some body please help
........

-Vaibhav Joshi
Click to expand...

Try:
Create a new database, open it and then select import to import the
contents of your 'crashing' database into the new one. See if that
solves the problem.
Catch:
You must re-create any references you've made in VBA (if any) because
they aren't imported...
 
V

Vaibhav Joshi

Thanks for providing a help ful tip. But I had already tried this and this
necessarily does not work. It also degenerates into creating another giant
bug which reports "Network Connection Lost".......... and does not let the
VBA Code execute. Is their any other way out.... ????

-Vaibhav Joshi
 
G

Gijs Beukenoot

From Vaibhav Joshi :
Thanks for providing a help ful tip. But I had already tried this and this
necessarily does not work. It also degenerates into creating another giant
bug which reports "Network Connection Lost".......... and does not let the
VBA Code execute. Is their any other way out.... ????

-Vaibhav Joshi
Click to expand...
<snap!>

Well, I guess not an easy one...

Same steps, create a new MDB, import all (tables, queries ,etc.)
_except_ the forms.
When finished, try to see if the error stays away. If so, make a backup
and start importing forms. Either one by one or, let's say, 10 at the
time. After each import, try if it works. If it does, backup and take
the next one (or ten).
You shoud find the offending form (if any) using this method. Then,
perhaps rebuild it or take it from a backup-copy

Regarding your "network connection lost" message, I guess that has
something to do with attached tables?? Relink the tables if so.

As mentioned earlier, the import doesn't copy references but it also
skips any startup stuff (like autoexecuting a form at startup). Adjust
that at the properties screen of your DB but wait unti the database
itself imported OK.

Hope this helps
 
Top