[AccessD] Folder 'Caching'

Dan Waters dwaters at usinternet.com
Tue Jun 19 11:21:59 CDT 2007


Thanks Charlotte!

Next week we're having a meeting at my customer site and I will bring a copy
of your email.

Thanks!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Tuesday, June 19, 2007 10:57 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Folder 'Caching'

If the front end or back end drives are set to cache now write later,
changes made on one front end might not show up in the back end
immediately or be cascaded to other front ends in a timely fashion.
Depending on how it was set up, it might delay the write until the
initial FE app closed.  Not what you want to happen.  I would imagine
that using a RAM Disk on any of the FE machines could also cause
problems like that.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Friday, June 15, 2007 6:38 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Folder 'Caching'

Hi Jim,

I should have said that my system is a FE/BE Access 2003 system.
Clients automatically pull updated FE files.  Even when they do this,
the new FE on the Client will think that it's supposed to link to the
previous BE file.
If the tables in the previous BE tables were changed, my system has
crashed because the new FE is trying to connect to the previous BE,
which no longer exists.  It only does this once - the next time someone
logs in after an update, everything runs smoothly.

VF!  (Very Frustrating)

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Friday, June 15, 2007 8:12 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Folder 'Caching'

Hi Dan:

I have only heard of the caching issue when relating to internet AJAX
applications. IE caches everything and if a data request appears to be
the same or very similar, it is just acquired from the cache. The
solution to the problem is to prefix the date-time to each new piece of
data.

Not sure whether this relates to you as I am not sure how far caching
use extends in the new programs.

Jim  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Friday, June 15, 2007 3:57 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Folder 'Caching'

Hello to all!

I have a customer who, about a year ago placed my system under a
networked folder they call Secured.  It took me a year, but I finally
was able to see a pattern of errors where updates to my system were not
'seen' by the first person who opened my system after an update, but
they were seen by the second person and subsequent people who opened it.
This has occurred where I made on change on Saturday morning and the
problem occurred on Monday morning.

Today we also experienced an email automatically sent to a Supplier that
had the wrong due date on it!  But when we looked into the back end
later, the date was correct.

Last week I attended a meeting with some IT folks at this company, and
one of them said that he believed the folder was caching changes, but he
didn't know the details. 

This is the only place I've ever heard of this happening.  And I still
don't know what the folder is actually doing.

Has anyone come across this situation?  Do you know what that folder is
actually doing?  Or, is there anything I can do to work around it?

Thanks!
Dan Waters

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


















































































































































































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