jwcolby
jwcolby at colbyconsulting.com
Mon Jan 17 07:53:29 CST 2011
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 >