[AccessD] Disconnected MS Access cient applications..

Jim Lawrence accessd at shaw.ca
Thu Aug 18 19:15:25 CDT 2005


Hi Shamil:

But do not get too fancy with the code your wish to translate or it bales
quite unceremoniously. Straight forward stuff works great but be careful
with different references and/or 'using' assemblies.

Great information Shamil :-) 
Jim  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil
Salakhetdinov
Sent: Thursday, August 18, 2005 1:43 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Disconnected MS Access cient applications..

> So much to know, so few years remaining.
The same problem here :(

Go C#! - just a week to start with it - and it's as high level programming
language as VB6/VBA, even higher.
And you will save a lot of time.
And the "cutest and coolest" stuff appears first of all in .NET Framework
for C#...

As for VB.NET -> C# conversion I recently used one of free online tools like
this one - http://www.carlosag.net/Tools/CodeTranslator/Default.aspx to
convert a lot of VB.NET code.
 In fact I did convert last autumn a lot of VBA code to VB.NET(three big MS
Excel Add-Ins) using VS.NET 2003 converter + of course manual conversion.
And then this July I converted VB.NET to C# using free online tools. Quite
some manual work is still needed but it's mostly mechanical. And I did spend
about two months to write original VBA code of these three MS Excel add-ins
VBA-> VB.NET conversion was done in a week and all worked OK.
C#->VB.NET conversion - it took a couple of days and all worked OK also of
course (but I didn't convert all the VB.NET code)

Shamil

----- Original Message ----- 
From: "John W. Colby" <jwcolby at colbyconsulting.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Friday, August 19, 2005 12:01 AM
Subject: RE: [AccessD] Disconnected MS Access cient applications..


> I have VS.Net 2002 and it isn't clear that it works with that.  I also
have
> VB.Net Express (2005).  In either case all I know at this point is that if
> you comment your code in some unknown format a tool will allow you to
export
> the comments to a help file.  Sigh.
>
> So much to know, so few years remaining.
>
> John W. Colby
> www.ColbyConsulting.com
>
> Contribute your unused CPU cycles to a good cause:
> http://folding.stanford.edu/
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil
> Salakhetdinov
> Sent: Thursday, August 18, 2005 3:47 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Disconnected MS Access cient applications..
>
>
> Yes, I do use it with but with C# projects.
>
> They (MS) have XML comments in VS.NET 2005's VB.NET (to be released this
> November?)
>
> As for VB.NET in VS.NET 2003 - I have heard there is a tool to work with
XML
> comments in it but I don't know how good it's - this is VBCommenter -
>
http://www.gotdotnet.com/workspaces/workspace.aspx?id=112b5449-f702-46e2-87f
> a-86bdf39a17dd - And it exports XML comments to be used by NDoc? I didn't
> check that but it's stated here:
>
> "NDoc generates class library documentation from .NET assemblies and the
XML
> documentation files generated by the C# compiler (or with an add-on tool
for
> VB.NET)." http://ndoc.sourceforge.net/
>
> Sorry, I don't have any more info on NDoc - I did start to use it just
last
> month...
>
> HTH,
> Shamil
>
> ----- Original Message ----- 
> From: "John W. Colby" <jwcolby at colbyconsulting.com>
> To: "'Access Developers discussion and problem solving'"
> <accessd at databaseadvisors.com>
> Sent: Thursday, August 18, 2005 11:23 PM
> Subject: RE: [AccessD] Disconnected MS Access cient applications..
>
>
> > Shamil,
> >
> > Do you use Ndoc?  I was just about to post a question on how to figure
> that
> > out and tie it in to my VB.Net projects.
> >
> > John W. Colby
> > www.ColbyConsulting.com
> >
> > Contribute your unused CPU cycles to a good cause:
> > http://folding.stanford.edu/
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil
> > Salakhetdinov
> > Sent: Thursday, August 18, 2005 2:48 PM
> > To: Access Developers discussion and problem solving
> > Subject: Re: [AccessD] Disconnected MS Access cient applications..
> >
> >
> > > 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
> >
> > --
> > 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