odbc sql server driver communication link failure -
i have access 2003 front-end sql 2005 back-end. occasionally, users error below , front-end crashes. pointers how can resolve this? [odbc sql server driver] communication link failure from googling , reading have done on topic, seems me might bug in ms access they've never bothered fix, ie: there is no resolution. the symptoms seeing , others seem have connection access has sql server becomes "bad", , once reaches state, nothing fix except restarting access, period. although blows person's mind, entirely possible - if code related connection management (either in ms access itself, or within odbc provider) doesn't check validity of connection state , assumes fine, see symptoms are seeing. you'd think, surely microsoft fix this, wouldn't first time. update i'm seeing same behavior when using microsoft access project (*.adp) problem appears within ms access (as opposed odbc).