[AccessD] Access XP forms bound to ADO recordsets

Hi All,

I did contact Steve Jorgensen on the subject - here are his answers reposted 
here with his permission:

<+++++++++++++++++++++++++++++++++++++++++++++++++
> I wanted to ask you: Did you broadly use this method in real life
> development since the summer 2002? Was it a success story or it
> happened to
> have side-effects, which can't be effectively worked around?
Alas, over time I've found that using Access with disconencted
recordsets is simply too unreliable to use.  It can seem to work for a
short time, but almost anything you try do to the recordset from code
after creating it will cause Access to crash shortly after the recordset
is bound to the form.  Even without touching the recorodset from code,
Access frequently crashes.  I've given up on the technique as a
practical tool.

> May I post this your information in AccessD discussion list?
> Do you have a sample app, which shows how MS Access crashes with forms
> bound to disconnected recordsets?
Yes - of course you may re-post it.  As for an example app, no I don't
have one at hand as all the code I wrote to do this has long since been
discarded.  I can tell you, however, that I had the problems with both
Access 2002 and 2003, and they were serious.  Access 2000 actually was
more reliable, but that's becoming an antique and has other reliability
issues in client/server applications.
++++++++++++++++++++++++++++++++++++++++++++++++++++>

This is a serious warning to not use this technique in real life 
applications.

But as I wrote recently I so far didn't see any MS Access crashes while 
using MS Access 2003 forms bound to ADODB recordsets.

I will try to find time to prepare stress test and to run it for several 
hours...

Shamil

----- Original Message ----- 
From: "Shamil Salakhetdinov" <shamil at users.mns.ru>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Monday, March 13, 2006 12:08 PM
Subject: Re: [AccessD] Access XP forms bound to ADO recordsets


>> I'll keep this and study it.
> Hi Dan,
>
> Please try to stress test it "to death" first of all because as I wrote in 
> a
> posting to John here there are rumors it forces MS Access to loose
> stability...
>
>> Having said all that, when I go to companies and tell them that I develop
>> in
>> Access, have been doing so for eight years, and show them how my system
>> works, the concern over Access drops off.
> Good news! I thought MS Access is getting "semi-dead"...
>
>> I am looking forward to what Access 12 will have in it.  I've seen some 
>> of
>> the descriptive material published by MS, and so far it looks great!
> Yes, it does look quite differently and most of the changes are mainly 
> power
> users oriented AFAIS - therefore MS Access developers may expect more 
> "messy
> software" to fix coming in their direction! :)
>
> Shamil
>

<<< tail skipped >>>