Access 2007 crashing with right click on subform

[dstork]

Has anyone else experienced Access 2007 crashing when users right
click on the subform (with the intention to use the copy feature in
the shortcut menu).

I went through Allen Browne's recommended checks (Name Autocorrect
Options, references, decompiling, etc) and I even tried installing
Office SP1 but no luck. (Access also crashes for me when right
clicking on the recordsource proptery of a Form).

ds

 

[Allen Browne]

I'm not getting that crash in A2007 SP1.
I wonder what's different.

Is your subform based on a query that uses more than 1 table?
If so, is there are text box for the foreign key field(s), i.e. the one(s)
named in LinkChildFields?

Re changing the RecordSource property: is this in design view?
Does it happen in any form, or a specific form?
Does it happen only after you make a change?
Does it still happen if you click somewhere else in the property sheet (e.g.
Recordset Type property) after making the change?

 

[ARC]

I have an app that always crashed when right-clicking in lower subforms. It
appeard to happen when I was using a tab control, with subforms, and even a
sub-sub form on one of the tabs. The sub-sub form in particular would crash
access 2007 every time.

As for my app, I'm considering reworking the interface to remove the tabs,
so I suspect that if I eliminate the need for 2 subforms deep, it wouldn't
crash, but that's just a guess.

I'm not sure if SP-1 fixed this, but I would suspect that it does. I haven't
yet loaded SP-1.

Hope this helps,

 

[Tony Toews [MVP]]

Has anyone else experienced Access 2007 crashing when users right
click on the subform (with the intention to use the copy feature in
the shortcut menu).

I've seen the same with a clients app. While the problem was quite consistent I
couldn't quickly get a simple repro. I've left that problem for now.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[dstork]

I'm not getting that crash in A2007 SP1.
I wonder what's different.

Is your subform based on a query that uses more than 1 table?
If so, is there are text box for the foreign key field(s), i.e. the one(s)
named in LinkChildFields?

Re changing the RecordSource property: is this in design view?
Does it happen in any form, or a specific form?
Does it happen only after you make a change?
Does it still happen if youclicksomewhere else in the property sheet (e.g.
Recordset Type property) after making the change?

--
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips forAccessusers -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.








- Show quoted text -

Allen,

I think the two issues are possibly related and that is why I
mentioned them in one post. I've even tried right clicking on a
"simple" form which pulls data from a single table (into the subform
with no tabs on the form) and still Access crashes.

As for right clicking in the properties window, it seems to crash no
matter what property I right click on (in the design view). It seems
to happen on any form. I simply open the form in design view, right
click on a property in the properties window and voila, it crashes.

I have imported all tables, queries, forms, etc to a new accdb,
recreated the same references and it does not crash. I suppose I
could go this way, but it would have been nice to know why.

Thanks.

ds

 

[ARC]

By the way, I had the exact same problem here too. Whenever I attempted to
right-click in the properties window to paste in a value, access 2007 would
crash. I had to break myself of the right click habit, and instead use
<Ctrl><Insert> to copy, then <Ctr>V to paste.

Oddly enough, after switching development machines to a new windows vista
computer, right-clicking no longer freezes access 07. My old pc was a
windows xp home edition sr-2, and right-clicking in the property sheet was
never a good thing.

I'm not getting that crash in A2007 SP1.
I wonder what's different.

Is your subform based on a query that uses more than 1 table?
If so, is there are text box for the foreign key field(s), i.e. the one(s)
named in LinkChildFields?

Re changing the RecordSource property: is this in design view?
Does it happen in any form, or a specific form?
Does it happen only after you make a change?
Does it still happen if youclicksomewhere else in the property sheet (e.g.
Recordset Type property) after making the change?

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips forAccessusers -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.








- Show quoted text -

Allen,

I think the two issues are possibly related and that is why I
mentioned them in one post. I've even tried right clicking on a
"simple" form which pulls data from a single table (into the subform
with no tabs on the form) and still Access crashes.

As for right clicking in the properties window, it seems to crash no
matter what property I right click on (in the design view). It seems
to happen on any form. I simply open the form in design view, right
click on a property in the properties window and voila, it crashes.

I have imported all tables, queries, forms, etc to a new accdb,
recreated the same references and it does not crash. I suppose I
could go this way, but it would have been nice to know why.

Thanks.

ds

 

[Mack]

Hi, I experience this problem too on a regular basis. It only seems to affect
legacy *.mdb databses, particularly those created with Access 2000 or Access
97. I can get the problem to fault reliably using the Video Collection
Database Access 2000 template from Microsoft. Load this into Access 2007 :
http://office.microsoft.com/en-au/templates/TC011817771033.aspx?CategoryID=CT102144001033
Then click on "Enter/View Videotapes".
Ensure your text cursor is in the "Description" field.
Now right click on any field below "Program Name" or "Actor".
This will cause Access 2007 to crash with a 0xC0000005 error code.
Hope this info assists Microsoft in repairing this bug.

 

[David Stary]

Thats problem occurs when import or transfer Access 2000,2003 database to
Access 2007 with user defined commandbars.
You must import/transfer all objects of previous version Access to 2007
except commandbars. Then create your custom ribbons using XML.

Good Luck
David

 

[Mack]

Many thanks for your input David. We have no user defined commandbars in our
database however, yet the problem still occurs. I also find that if when
typing into a text field the system prompts you to change the capitalisation,
then when you do so, more often than not it will crash Access corrupting your
database if you're not careful. Two dastardly problems that I wish we didn't
have to deal with.

Cheers, Mack

 

[Finlay]

Access 2007 subform right click crashes system

All,

had the same issue with a subform on a tab.

replaced the standard right click menu with a custom one imported from an access 2003 database.

That solved my problem.