Shamil Salakhetdinov
shamil at smsconsulting.spb.ru
Mon Jan 17 09:01:34 CST 2011
John -- You decide. In fact subcontracting in that case of small "quick&dirty" .NET based solution (3 x 20 "bound" forms + a few reports?) would more profitable for you in long run I suppose: - you'd not need to spend(/waste) time on looking "legacy" workarounds now - is that work paid? - I guess not. You don't have now any other profitable for you "paid instantly when done" kind of work?; - you'll own all work made by subcontractors; - subcontractors would need to do just forms and a few(?) reports - all the rest MS SQL data model, views, UDFs, SPs (+ "quick & dirty" specs) - would be your work - and you can get paid for that immediately as you know how to do it... - ... The world of modern custom development (and subcontracting) has changed "dramatically" during just a few last years - the one with "quick reaction" wins more and more often - I can't say I like it that much as I'm getting older and I haven't yet fulfilled my "early retirement plan"... You decide. Thank you. -- Shamil -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: 17 ?????? 2011 ?. 16:53 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access to SQL Server over Hamachi - it WORKS I will be doing all of this. Except for hiring someone to do anything for me. This is a no-charge gig. ;) I can't be paying someone to do it for me. John W. Colby www.ColbyConsulting.com On 1/17/2011 8:36 AM, Shamil Salakhetdinov wrote: > John -- > > I can be wrong but making 20 simple bound WinForms can be done in a > couple of hours provided forms' queries are ready or forms are > directly bound to the db tables. > No custom formatting included in that work - but that's an additional > work and it usually takes less/the same time as with MS Access... > And WinForms bound forms are a very different story to MS Access bound > forms > - I mean they (WinForms) are bound (to ADO.NET datasets, ...) but > disconnected... > > MS ReportViewer reports - if you have to develop many of that - > subcontract young developers there or you can develop MS ReporViewer > reports using advanced but free MS Report Builder 3.0 > (http://msdn.microsoft.com/en-us/library/dd207008.aspx) or MS > ReportBulder 2.0... > > And no "legacy burden" at all. > Some "learning curve stress" - yes, but that will be a positive stress > with very fruitful outcome in long run... > > You decide. > > Thank you. > > -- > Shamil > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby > Sent: 17 ?????? 2011 ?. 16:00 > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Access to SQL Server over Hamachi - it WORKS > > > Just my opinion: I suppose you're stepping back/putting "legacy burden" > on your own: doing .NET C#/VB.NET development, bound .NET WinForms and > MS ReportViewer reports would be preferrable solution in your project context.. > > It would and that is where I am headed. > > For all of the C# development I have done in the last 16 months, none > was the standard database form / subform data entry stuff. The reason > I am even doing the Access thing is simply that I can do the entire > thing in a matter of hours (bound). I am only talking under 20 tables > / forms and then some reports. > > Once I get the infrastructure nailed (SQL Server on VM over Hamachi > with a > run-time) I can knock out three different tiny projects in perhaps two > or three days work. > > I actually did the .Net data form thing back in my C# class starting > in Sept 2009, but I haven't looked at that since. In my stuff we do > everything in code and (to this point) don't really use forms to look > at or enter data directly in tables. > > Anyway... I will be going there, specifically to replace these Access > FEs but I can get these three jobs "off my back" with a quick and > dirty Access design. > > John W. Colby > www.ColbyConsulting.com > > On 1/17/2011 7:17 AM, Shamil Salakhetdinov wrote: >> Hi John -- >> >>> I can do things like bind the form to an ADO recordset and still >>> have it read/write. >>> I will need to learn >>> how to use a stored procedure were I can pass in a PK and have the >>> SP return a table of data already selected and sorted. I.e. SQL >>> Server doing the lifting. >> >> Just my opinion: I suppose you're stepping back/putting "legacy >> burden" on your own: doing .NET C#/VB.NET development, bound .NET >> WinForms and MS ReportViewer reports would be preferrable solution in >> your > project context.. >> >> Thank you. >> >> -- >> Shamil >> >> >>> >>> -----Original Message----- >>> From: accessd-bounces at databaseadvisors.com >>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby >>> Sent: Sunday, January 16, 2011 7:21 PM >>> To: Access Developers discussion and problem solving; VBA; >>> Sqlserver-Dba >>> Subject: [AccessD] Access to SQL Server over Hamachi - it WORKS >>> >>> Today I stepped back and set it all up internal to my network. >>> >>> Yesterday I had moved the Fe to my laptop. Today I deleted all of >>> my linked tables, then I relinked all of the tables. In doing so I >>> created a new DSN where I hit the SQL Server directly at the Hamachi >>> IP address. Relinked using this new DSN and voila, she's a wurkin, >>> and lightning fast over my internal network but forcing the traffic >>> through Hamachi. >>> >>> So I tested a bit, then went back out to the local Arby's where I >>> was pretty much unable to do anything last night (other than browse >>> the internet). Got right on the connection, opened the Access FE >>> and voila, she's a wurkin, and lightning fast. You wouldn't know >>> you weren't directly on my LAN. >>> >>> Access on my laptop over Hamachi, over a public network, in to my >>> network, directly into a Virtual Machine over Hamachi, running SQL >>> Server 2008 Express. >>> >>> I am so jazzed! that leaves me with one technical barrier now, >>> getting an Access 2007 run-time to host an Access 2003 FE. >>> >>> Now I need to set up a VM to run on my laptop so that I can have an >>> environment without Office installed. Install the Access 2007 >>> run-time and drop the Access 2003 Fe in place. Set up Hamachi on >>> that VM and then get it all playing nice. >>> >>> This will allow me to take my laptop on the road to demo the system. >>> >>> We shall see. >>> >>> And yes Jim, I understand I still need to cause SQL Server to do the >>> heavy lifting. To this point I have never really used SQL Server as >>> the BE for Access. My biggest client uses Access 2K and it doesn't >>> really play nice with ADO. Since I can now develop these new >>> databases in 2003, I can do things like bind the form to an ADO >>> recordset and still have it read/write. >>> I will need to learn >>> how to use a stored procedure were I can pass in a PK and have the >>> SP return a table of data already selected and sorted. I.e. SQL >>> Server doing the lifting. >>> >>> The nice thing is that these are small databases so I can do things >>> like leave the list tables just linked, at least for awhile while I >>> learn all the stuff I have never had to do. >>> >>> Next up, 2007 run-time. >>> >> > -- > 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