In MS Access assigning RecordSource doesn't report errors

M

MNF

In the MS Access XP(2002) Project (ADP) I've noticed some strange
behavior when dynamically assign form's me.RecordSource.
me.RecordSource=sSQLForLongRunningQuery
According to the documentation it automatically invokes Requiry, but
if the query is running too long (not sure 30sec or more) assignment
is silently cancelled and the previous value of me.RecordSource is
used.
It obviously causes unexpected behaviour for the users.

Michael Freidgeim
http://www.thespoke.net/MyBlog/MNF/MyBlog.aspx
 
Top