[AccessD] Disconnected MS Access cient applications..

Charlotte Foust cfoust at infostatsystems.com
Thu Aug 18 13:23:58 CDT 2005


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



More information about the AccessD mailing list