deleting problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I've got form (F)+ subform (S1) + sub subform (S2) situation.
When I try to delete record from S1 it properly reports that it can't be
done because referential integrity between S1 and S2. When I delete all corensponding
rows in S2 and try to delete again from S1 that same row I had tried to delete erlier
I get no message at all but cursor turns in that 'wait' cursor type and form gets frozen.
Only Ctl+Alt+Delete helps.
What could be happening?
Thanx

alekm
 
Hi,
Not sure if this is the problem, but you might try to
refresh the data after you delete from S2
(Records/Refresh). It may be that the deletion process is
simply "marking" records for deletion and the attempt to
delete from S1 causes confusion internally. A refresh
might make the S2 records actually go away, and the S1
delete can proceed smoothly.

Hope this works.

-----Original Message-----
Hi,
I've got form (F)+ subform (S1) + sub subform (S2) situation.
When I try to delete record from S1 it properly reports that it can't be
done because referential integrity between S1 and S2.
Click to expand...
When I delete all corensponding
rows in S2 and try to delete again from S1 that same row I had tried to delete erlier
I get no message at all but cursor turns in that 'wait'
Click to expand...
cursor type and form gets frozen.
 
Hi,
I've just found out that I've got problems aloso with deleting records
from S1 that had never hag coresponding rows in S2 (form gets frozen).
I've also found out that it happens in Access 2000 but in Access 2003
deleting work fine!
Do I need some patches for Access 2000?
Suggestions?
Thanx
alekm
 
Afraid I can't help there. I'm using Access 97, although
we'll be migrating to 2000 later. I'll keep your problem
in mind for my own reference! Meanwhile, suggest you post
a new item mentioning A2000/2003, maybe asking for MVP
help, so that others more knowledgeable will see it and
jump in - they might not mess with an older post with
responses showing. You might also check the Knowledge
Base to see if that issue has been addressed.

Good luck
 
Back
Top