J
Justin
Good morning,
After installing SP3 on machines throughout our organization, we've
discovered that Access will consistently crash when trying to delete certain
records. I've been able to duplicate it with different databases on
different workstations consistently.
1. Create a simple access database with two tables.
2. Create a foreign key in table2 and create the 1-to-many relationship (w/
cascade deletes).
3. Add a few records in each table.
4. Open up the table with the "1" in the 1-to-many relationship. You
should have a (+) sign next to each row you can click to see the
5. If you delete a record without expanding the row to show the related
rows first, it will delete w/o a problem. However, if you expand the row and
then collapse it, Access 2003 w/ SP3 will crash.
In case the steps above aren't clear, here's a screencast of the steps I'm
talking about:
http://www.screencast.com/users/Jus...ng/media/80481f97-6438-4dca-99cd-9f84fc003ec4
You'll notice in the screencast that it doesn't seem to matter if the child
table actually has any related records for the row you want to delete; Access
still crashes whether there are related rows or not.
In the screencast, I'm using v11.8204.8172, but we've seen the same issues
w/ 11.8166.8221. This same process worked fine on this machine when I had
v11.6566.6568 (SP2) installed, but Access started crashing immediately after
installing SP3 on my test box.
I've tried the various post-SP3 hotfix packages I found, but none seemed to
help. Haven't been able to find any other relevant hotfixes, either.
Any suggestions? Hotfix or something I'm overlooking?
Thanks,
Justin
After installing SP3 on machines throughout our organization, we've
discovered that Access will consistently crash when trying to delete certain
records. I've been able to duplicate it with different databases on
different workstations consistently.
1. Create a simple access database with two tables.
2. Create a foreign key in table2 and create the 1-to-many relationship (w/
cascade deletes).
3. Add a few records in each table.
4. Open up the table with the "1" in the 1-to-many relationship. You
should have a (+) sign next to each row you can click to see the
5. If you delete a record without expanding the row to show the related
rows first, it will delete w/o a problem. However, if you expand the row and
then collapse it, Access 2003 w/ SP3 will crash.
In case the steps above aren't clear, here's a screencast of the steps I'm
talking about:
http://www.screencast.com/users/Jus...ng/media/80481f97-6438-4dca-99cd-9f84fc003ec4
You'll notice in the screencast that it doesn't seem to matter if the child
table actually has any related records for the row you want to delete; Access
still crashes whether there are related rows or not.
In the screencast, I'm using v11.8204.8172, but we've seen the same issues
w/ 11.8166.8221. This same process worked fine on this machine when I had
v11.6566.6568 (SP2) installed, but Access started crashing immediately after
installing SP3 on my test box.
I've tried the various post-SP3 hotfix packages I found, but none seemed to
help. Haven't been able to find any other relevant hotfixes, either.
Any suggestions? Hotfix or something I'm overlooking?
Thanks,
Justin