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