Access 07 Crashing still after SP1

[bart.nissen]

Hello,

I asked this earlier this year to no avail. We have three different
programs (were 03 and worked fine) that we still can not right click
in all datasheets that are in a subform, if you right click on a field
in a column that doesn't have focus or control, Access shutsdown/
crashes. If you left click first on any field, then right click on
that data field, no problem. We have done this on ten different PCs
running XP SP3 and Vista. Has anyone else encountered this?

Things we have tried:
1. Convert to 07.
2. Run as 03 in 07.
3. Built new 07 and imported all forms, tables, macros, etc.


If we turn off the shortcut key on the forms, then no problems. If we
have the datasheet as a form (not a subform), right click works fine.

To recreate my problem, create a form on any table, create another
form and make the first form a subform. Then make the subform default
view datasheet. Right click in any field that does not have control/
focus.

Any help would be greatly appreciated.


Bart

 

[Ken Snell \(MVP\)]

Another MVP has tried to reproduce your error, using ACCESS 2007 SP1 with
Vista OS -- he tested both an .mdb file and an .accdb file. He's unable to
reproduce it.

Have you looked at this Knowledge Base article; this hotfix may not be in
SP1 (though we would expect that it is):
http://support.microsoft.com/kb/935875/

Otherwise, perhaps there is something else that is causing this error? Can
you give us more details about the setup that you're using?

 

[Paul Shapiro]

I haven't seen that problem, but you mention curing it by disabling a
shortcut key on the form. Any db I created from SourceSafe in Access 2003
and then removed from SourceSafe control had a few corrupted forms that gave
an out-of-memory error when opening in Access 2007. Removing shortcut keys
in the form cured the corruption. I worked with MS tech support who found
another solution. Open every form in the db in Access 2003 before ever
trying to open the db in Access 2007. I wrote a short routine to
automatically open and close all forms.

 

[Glenn Siswick]

Bart,

I too have just found exactly the same problem with a database originally
written in A2K and recompiled to run in A2007. Even more strange though is
that I have another database with the same sceanario (datasheet as a subform)
and the right-click shortcut works just fine.

Both are running on XP professional OS, and both worked fine in A2003.

If I discover anything will let you know.

Glenn.