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

Darryl,

You have to understand that:

1) In Access I am a bound kinda guy.
2) Bound is the absolute fastest dev mode if the infrastructure supports it.
3) This is a short term solution to get something into the hands of the client
4) Access will go away when I learn how to do database forms in C#.

There is just no point in spending all of the time to learn how to do unbound for Access.  Long term 
I have no intention of doing Access projects anymore.

To this point I have done 16 months of extensive programming in C# but all of it was manipulating 
huge tables in SQL Server, tens of millions of records.  I have exactly *one* pair of tables which 
would ostensibly be a "typical" parent / child / data entry kind of thing, and even there the parent 
record is created by code and the child records are created by other code when the parent records 
are manipulated by code.

So for all of my 16 months daily programming, I simply have not done the "data entry form" thing.

All three of the systems I need to deliver are tiny, under 20 tables at this point.  All of them are 
for non-profit organizations no-charge.  I need to minimize my costs, not spend a ton of time to 
learn how to do unbound in Access for an environment I have no intention of continuing to develop in 
long term.

If I were doing this to run on a LAN I would whip out an entirely bound solution.  It would take me 
couple of days per client.  I would deliver and be done.  Unfortunately in each case these clients 
have no central office, and in fact they do not even have a web page that I can use for hosting the 
database, not that the web host provider would be common between the clients.

Again, I need to cut my losses on this.

I create a VM to run on my servers.
I host the databases on that vm.
I set up vpn into my vm.
I develop the quickest solution that actually works.

John W. Colby
www.ColbyConsulting.com

On 1/17/2011 12:50 AM, Darryl Collins wrote:
>
> _______________________________________________________________________________________
>
> Note: This e-mail is subject to the disclaimer contained at the bottom of this message.
> _______________________________________________________________________________________
>
>
>
> heh, I was thinking exactly that, but didn't want to mention the war ;)
> Seriously, pull in (unbound) just what the users asked for and nothing more, update it back to SQL Server the same way.
>
> And thanks for the update John, you really do want to publish this stuff.  I know am I going to learn heaps for this experience.
>
> cheers
> Darryl.
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
> Sent: Monday, 17 January 2011 4:25 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Access to SQL Server over Hamachi - it WORKS
>
> I think we have been arguing this forever but at the risk of starting
> another bound/unbound war here is the following.
>
> Who binds MS SQL Server to any forms? That is why a programmer uses a real
> SQL Server... no binding is really necessary.
>
> ...and that will cut your performance drag dramatically.
>
> Jim