[AccessD] Find First in an Array?

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Fri Feb 20 17:47:36 CST 2009


In the case of this app, however, there can be multiple back ends in
different locations.  So to get them updated I'd have to send out an update
program.  Or embed the updates in the next release of the front end.  And
check each back end that gets opened to see if the latest updates were in
there.  Actually, keeping the latest Language table in the front end and
transferring it to the back end on opening each time would ensure that the
back end was up to date.  

But at that point, with the language table in the front end anyway, wouldn't
it make sense just to run the translations from the front end table? 


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Friday, February 20, 2009 1:50 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Find First in an Array?

And this is where Global Classes come into play.

In the case of your multi-lingual app, your data may not change very often,
but it has the potential to change.  That being the case, by putting the
data in the BE, you don't have to update the FE for a simple data change.
However, instead of constantly pulling the data across from the BE, you load
the class when your app starts up, and the data is simply kept in memory.

Pulling a few thousand records really isn't a big deal, as long as they
aren't memo fields with megs of information.  2.5k records, with even 1k cay
of information is only going to use 2.5 megs of RAM (roughly)  In the case
where you are storing a few bytes of info, it's negligent, especially on
machines where 1 to 2 gig is standard RAM.

Even in situations like a State table (TX, AL, FL, etc.).  Sure, there are
50 states now, but putting lookup tables in the FE can lead to unnecessary
mass updates.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Friday, February 20, 2009 2:06 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Find First in an Array?

" I am not going to get into the "this is a local table so it goes in the
FE... oh damn, now I gotta go update the data in 5 different FEs".  BEs are
for data (in my world)."

In my case, where the 'data' is really static, and is needed by each user,
wouldn't the design be better with the language tables in the FE?


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

The information contained in this transmission is intended only for the
person or entity to which it is addressed and may contain II-VI Proprietary
and/or II-VI Business Sensitive material. If you are not the intended
recipient, please contact the sender immediately and destroy the material in
its entirety, whether electronic or hard copy. You are notified that any
review, retransmission, copying, disclosure, dissemination, or other use of,
or taking of any action in reliance upon this information by persons or
entities other than the intended recipient is prohibited.


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