[AccessD] Disconnected MS Access cient applications..

Shamil Salakhetdinov shamil at users.mns.ru
Thu Aug 18 13:48:09 CDT 2005


> Like Nunit testing, for instance.  Now THERE's a topic I
> could get excited about if someone would like to rewrite it to work with
> VBA ...
So, you wanted JUnit/NUnit ideas ported to MS Access/VBA?
We're thinking in the same direction :)
Do you think it could be broadly used? (VBA is getting "dead" language?)

Yes, VBA/Access Unit  testing can be done several ways.
I'd use open source NUnit sources for starters....
Rough estimation: not that much work - one/a couple of months  - anybody to
sponsor? :)

What about NDoc(http://ndoc.sourceforge.net/) ?
Also wanted to port it to VBA? - no problem - any sponsors? :)

Shamil

----- Original Message ----- 
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Thursday, August 18, 2005 10:23 PM
Subject: RE: [AccessD] Disconnected MS Access cient applications..


> Yes, I work with ADO.Net a lot, but in VB.Net, not Access, and I haven't
> even looked at C#.  Most of my time is now spent in VB.Net, but I keep
> thinking of how nice it would be to be able to do some of these things
> with Access ... Like Nunit testing, for instance.  Now THERE's a topic I
> could get excited about if someone would like to rewrite it to work with
> VBA ... Hint, hint, hint. ;-}
>
> Charlotte
>
>
> -----Original Message-----
> From: Shamil Salakhetdinov [mailto:shamil at users.mns.ru]
> Sent: Thursday, August 18, 2005 11:04 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Disconnected MS Access cient applications..
>
>
> > but have never had time to really pursue it.
> Yes, the same thoughts/experience here.
> Finally ADO.NET and WithEvents should make it rather easy to
> implement...
>
> I think/plan, I will return to this subject end of the next week,
> hopefully with some new results to publish as public domain/open
> source...
>
> Meanwhile I have to finish reading two books about XP in C#  and "MS
> Object Thinking" and make some experiments in ADO.NET and a good
> progress in a pending urgent project...
>
> Any ideas about directions in which to develop this small project are
> very welcome!
>
> Thank you for your support!
>
> Shamil
>
>
> ----- Original Message ----- 
> From: "Charlotte Foust" <cfoust at infostatsystems.com>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Thursday, August 18, 2005 9:30 PM
> Subject: RE: [AccessD] Disconnected MS Access cient applications..
>
>
> > Not interesting, Shamil, FASCINATING!  Yes, I do hope you continue
> > this thread.  Please!  I've often thought of this kind of thing but
> > have never had time to really pursue it.
> >
> > Charlotte Foust
> >
> >
> > -----Original Message-----
> > From: Shamil Salakhetdinov [mailto:shamil at users.mns.ru]
> > Sent: Thursday, August 18, 2005 10:02 AM
> > To: Access Developers discussion and problem solving
> > Subject: Re: [AccessD] Disconnected MS Access cient applications..
> >
> >
> > Charlotte,
> >
> > Your <VBG> means you're interested in continuation of this
> > subject/thread or...? In my plans is to extend and make all the source
>
> > code available. How soon it will happen this is an open question - I
> > have an urgent project here. But I do plan to continue this thread and
>
> > work if this looks interesting for you and others here. Maybe even
> > make it open source project here when first useful results will be
> > achieved? It would be interesting I guess to make it also XP(eXtreme
> > Programming) style work with your being subject area expert - I mean
> > your best knowing in what scenarios and in what business areas is the
> > best to use MS Access in bound but disconnected mode with most of the
> > software (MS Access FE
> > databases) developed by power users but integrated by "mighty MS
> > Access developers"? :)
> >
> > I know how to do all that, I know how to make MS Access applications
> > assembly factories etc. - I have all that experience and I can share
> > it if/when I will have spare time - is that interesting?
> >
> > Shamil
> >
> >
> > ----- Original Message -----
> > From: "Charlotte Foust" <cfoust at infostatsystems.com>
> > To: "Access Developers discussion and problem solving"
> > <accessd at databaseadvisors.com>
> > Sent: Thursday, August 18, 2005 7:35 PM
> > Subject: RE: [AccessD] Disconnected MS Access cient applications..
> >
> >
> > > Oooohhh, I think I'm in love!  <VBG>
> > >
> > > Charlotte Foust
> > >
> > >
> > > -----Original Message-----
> > > From: Shamil Salakhetdinov [mailto:shamil at users.mns.ru]
> > > Sent: Thursday, August 18, 2005 4:46 AM
> > > To: Access Developers discussion and problem solving
> > > Subject: Re: [AccessD] Disconnected MS Access cient applications..
> > >
> > >
> > > No, William, this is not replication - here is what I mean in short:
> > >
> > > http://www.smsconsulting.spb.ru/shamil_s/articles/ddo.htm
> > >
> > > Shamil
> > >
> > > ----- Original Message -----
> > > From: "William Hindman" <dejpolsys at hotmail.com>
> > > To: "Access Developers discussion and problem solving"
> > > <accessd at databaseadvisors.com>
> > > Sent: Thursday, August 18, 2005 3:47 AM
> > > Subject: Re: [AccessD] Disconnected MS Access cient applications..
> > >
> > >
> > > > Shamil
> > > >
> > > > ..I must be missing something ...that sounds like replication to
> > > > me.
> > > >
> > > > William
> > > >
> > > > ----- Original Message -----
> > > > From: "Shamil Salakhetdinov" <shamil at users.mns.ru>
> > > > To: "!DBA-MAIN" <accessd at databaseadvisors.com>
> > > > Sent: Wednesday, August 17, 2005 7:28 PM
> > > > Subject: [AccessD] Disconnected MS Access cient applications..
> > > >
> > > >
> > > > > Hi All,
> > > > >
> > > > > I wanted to ask you - what about the subject?
> > > > > Anybody uses/interested to use MS Access client applications
> > > > > this way?
> > > > >
> > > > > Do I miss obvious (RTFM) stuff and such a disconnected mode is
> > > > > already implemented in MS Access and broadly used by MS Access
> > > > > developers? Yes,
> > > I
> > > > > know ADO recordsets can be used with bound MS Access forms etc.
> > > > > but this looks like a rather limited feature - am I wrong?
> > > > >
> > > > > What I mean is cashing data locally into mdbs, only the data
> > > > > needed for the currently open form(s) etc., processing this data
>
> > > > > and then updating backend database(mdb, MSDE, MS SQL,
> > > > > whatever...)
> >
> > > > > - with all this cashing and updating made mostly automatically
> > > > > by a tiny framework code, based
> > > on
> > > > > ADO.NET...(yes, this local caching of data is not a new subject
> > > > > but nowadays it can be (re-)implement really scalable way with a
>
> > > > > way less efforts
> > > than
> > > > > before)
> > > > >
> > > > > Maybe MS plans to do something like that?
> > > > >
> > > > > Is that a wheel reinvention or anybody here sees such
> > > > > opportunity like a really useful feature in their real life
> > > > > projects?
> > > > >
> > > > > For me it looks like a useful feature because it could help: to
> > > > > get MS Access back into mainstream development area because it
> > > > > will allow to easily scale applications with MS Access
> > > > > front-ends...
> > > > >
> > > > > There are many other ideas but most of them in this "ideas pool"
>
> > > > > based
> > > on
> > > > > the subject one - if it doesn't make sense for real-life
> > > > > projects then
> > > I'd
> > > > > better stop working on it...
> > > > >
> > > > > What is your opinion about the subject?
> > > > > When you expect MS will do something like that in MS Access?
> > > > >
> > > > > Thank you,
> > > > > Shamil
> > > > >
> > > > > --
> > > > > AccessD mailing list
> > > > > AccessD at databaseadvisors.com
> > > > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > > > Website: http://www.databaseadvisors.com
> > > > >
> > > > --
> > > > AccessD mailing list
> > > > AccessD at databaseadvisors.com
> > > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > > Website: http://www.databaseadvisors.com
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > -- 
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com




More information about the AccessD mailing list