S
sswan
I have an interesting problem. I am using Access 2002 frontend and SQL
backend.
I have 3 forms which all share 1 subform. The subform adds\updates a
table in SQL and is linked to the parent form using the child\master
fields.
On two of the parent forms, the subform updates the table without any
trouble but on the third I get a timeout error. After the error - the
subform starts to work correctly and I don't have any more trouble
until I load the form again.
The fact that the subforms performs satisfactorily on two of the
parent forms suggests that there isn't a problem there and the problem
is with the parent form.
Parent forms 1 & 2 are linked to tables with small record counts and
form 3 is linked to a table with about 20,000 records so there is
obviously an issue with the size of the record set in the parent form.
The subform displays the data correctly - it only hangs when you try
to do the first update.
Any ideas?
backend.
I have 3 forms which all share 1 subform. The subform adds\updates a
table in SQL and is linked to the parent form using the child\master
fields.
On two of the parent forms, the subform updates the table without any
trouble but on the third I get a timeout error. After the error - the
subform starts to work correctly and I don't have any more trouble
until I load the form again.
The fact that the subforms performs satisfactorily on two of the
parent forms suggests that there isn't a problem there and the problem
is with the parent form.
Parent forms 1 & 2 are linked to tables with small record counts and
form 3 is linked to a table with about 20,000 records so there is
obviously an issue with the size of the record set in the parent form.
The subform displays the data correctly - it only hangs when you try
to do the first update.
Any ideas?