If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
ODBC upate on a linked table failed
I have a form that allows the user to Edit and Filter (properties). The
record source is a table (i.e., Student) linked with a second table by a key, i.e., RoomID with one-to-many relationship. The user forgot to input data into one field (nvarchar datatype) on the form. When he goes back to the record and input a value, it pops up an error message, "ODBC update on a linked table failed. Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). (#217). How can I fix it? Thanks |
#2
|
|||
|
|||
ODBC upate on a linked table failed
On Mon, 8 Feb 2010 06:03:01 -0800, Tim
wrote: You possibly have a bad trigger on that table. Check that first. -Tom. Microsoft Access MVP I have a form that allows the user to Edit and Filter (properties). The record source is a table (i.e., Student) linked with a second table by a key, i.e., RoomID with one-to-many relationship. The user forgot to input data into one field (nvarchar datatype) on the form. When he goes back to the record and input a value, it pops up an error message, "ODBC update on a linked table failed. Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). (#217). How can I fix it? Thanks |
#3
|
|||
|
|||
ODBC upate on a linked table failed
Tom, thanks for response. I do have an update trigger on this Student table.
Whenever the user inputs a value, say, Title, will trigger another field in this Student table to be updated. But these fields have nothing to do with the nvarchar field I mentioned. I suspect this nvarchar field is empty or null and the trigger has no code to deal with null or empty field. However, the form_close event and field_exit event have been programmed to pop up a message prompting the user to input a value for this field. So it's strange to me. Do you have any idea? Thanks "Tom van Stiphout" wrote: On Mon, 8 Feb 2010 06:03:01 -0800, Tim wrote: You possibly have a bad trigger on that table. Check that first. -Tom. Microsoft Access MVP I have a form that allows the user to Edit and Filter (properties). The record source is a table (i.e., Student) linked with a second table by a key, i.e., RoomID with one-to-many relationship. The user forgot to input data into one field (nvarchar datatype) on the form. When he goes back to the record and input a value, it pops up an error message, "ODBC update on a linked table failed. Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). (#217). How can I fix it? Thanks . |
Thread Tools | |
Display Modes | |
|
|