Access 2003 - Keeps Crashing

[Craig Alexander Morrison]

Any developers notice how Access 2003 keeps crashing when they are designing
tables and making a series of updates to table structures.

Many a time I would add a few fields to an existing table then close it
being prompted to save the table, clicking yes and..... Sorry Microsoft
Access has encountered.... It does seem to happen more often if you open the
table and make a design change and then save it and open it again to make
another change.

It never seems to cause any corruption. I can recreate the problem until I
do a decompile and compact. I have tried to recreate the problem in Access
97, it never crashes, do you know I do not think Access 97 has ever crashed
since I started using it nearly 10 years ago.

I also get this sometimes when I change a subform, and it does not quite
work, usually by copying one subform, renaming it and then changing it
recordsource and the link fields. I have noted that this is a common problem
and is easily avoided by making sure the LinkChildFields is set correctly,
this needs to be fixed (hopefully in SP2) as it is annoying when you are
creating a complex series of similar subforms.

I like Access 2003 indeed it is now being used in preference to Access 97
for our new developments, just this is annoying.

Does anyone else have this experience? Wonder if it will be fixed in SP2.

--
Slainte

Craig Alexander Morrison

Note: Track Name AutoCorrect is Off and all SubDatasheets are set to [none]

 

[Craig Alexander Morrison]

Ooops, did not mean to post this twice.