sql - MS Access Asynchronous Queries -

i have basic select query fired access form takes while execute, run query asynchronously , allow users continue using form (or @ least keep them updated on progress).

the problem access freezes application when code being executed, appearing users have crashed - point of windows marking 'not responding' , offering kill it. not user-friendly! have tried using code listed on msdn here , variant method here.

both these solutions seem run query 'asynchronously' (the code block firing async query completes, , rs_fetchprogress , rs_fetchcomplete events (or cn_executecomplete event in second solution) fire , run... access's interface still locks until query done executing. calling repaint , doevents in various places (such rs_fetchprogress event) not seem have effect.

i doubt it's relevant information, view being selected in sql server, view doesn't return huge amount of data take 20 seconds process.

do not pull huge recordset when open form. base form on query pulls few or no records when first loads. give users method select different reasonably-sized subset of records.

try avoid pulling huge recordsets regardless of whether data source linked access table or client-server database.