[AccessD] Access to SQL Server over Hamachi - it WORKS

jwcolby jwcolby at colbyconsulting.com
Mon Jan 17 06:59:59 CST 2011


 > 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.
>>
>



More information about the AccessD mailing list