Shamil Salakhetdinov
shamil at smsconsulting.spb.ru
Mon Jan 17 07:36:27 CST 2011
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