[AccessD] Performance tips anyone?

Jim Dettman jimdettman at verizon.net
Thu Jul 5 14:00:27 CDT 2007


Charlotte,

  I side with John on this one.  If your going to use Access unbound, you
might as well not bother.  

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Thursday, July 05, 2007 1:41 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Performance tips anyone?

Hey, count me in that group with Drew, John.  Access isn't hard to use
unbound.  You just have to write the same code you would have to write
in *any* language to work with unbound objects.  The freedom is
certainly worth the sacrifice of the bound uh ... "boundaries".  Your
problem is that it doesn't play nicely with your framework!!

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, July 05, 2007 10:32 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Performance tips anyone?

Drew,

>But Access is just as well suited for unbound solutions too.

Just as well suited as what?  Access is NOT as well suited for unbound
as it is for bound.  Access just has TONS of features in it directly
dependent on bound forms and controls.  Unbounders throw all that stuff
away; To try and implement that stuff in an unbound solution requires a
LOT of custom code.
AFAICT most Access "unbounders" make no effort to recreate most of what
Access just "gives" us bounders.

And Access is certainly NOT as well suited for unbound as VB.Net (or
even VB 6), not that I am an expert in .Net yet.  But you are talking a
whole nother ball game when you talk .Net.

So as much as I love ya, I have to disagree with that one.  I think you
are one of the "been doing Access unbound so long you forgot the pain"
folk.

John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Thursday, July 05, 2007 1:16 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Performance tips anyone?

But Access is just as well suited for unbound solutions too.  The only
exception to that rule is it's goofiness with callback routines. (Can't
go into debug if you have a callback routine ANYWHERE.  Goes haywire).

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, July 05, 2007 11:30 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Performance tips anyone?

Jim,

>You mentioning this will not cause near the stir as it did 10 years ago
as
most (all?) have now accepted the reality. ;-)

LOL, no not quite.  Access is a tool built from the ground up for bound.
To
even discuss unbound for Access NOW, when much more robust unbound tools
are available is ... well... kinda silly.  Unless of course you have
been doing unbound with Access for the last 10 years in which case you
have the expertise to do so.  Telling the average Access nubee to use
Access unbound is IMHO a disservice to the nubee.  He might as well just
go learn VB.Net.

As for me, if I need unbound it will be in VB.Net, NOT in Access (and I
am not an Access nubee).

The right tool for the job so to speak.   


John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Thursday, July 05, 2007 12:13 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Performance tips anyone?

Yes, Drew you have hit on the key to performance... 'unbound'. 

You mentioning this will not cause near the stir as it did 10 years ago
as most (all?) have now accepted the reality. ;-)

Jim     


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




More information about the AccessD mailing list