[AccessD] Data Refresh Problem

Unfortunately, I can not be of much help with this but have experienced this
condition for years with a large variety of 'bound' Access sites.

Traditionally, if given the mandate, I convert the site to 'unbound' with a
MS SQL BE and the client has never had that problem afterwards.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow
Sent: Wednesday, October 24, 2007 9:24 AM
To: _DBA-Access
Subject: [AccessD] Data Refresh Problem

Has anyone experienced Access FE forms (2k-2k3) not refreshing properly over
a network?
 
1GB Ethernet to the BE. All other work stations work well but this
particular WS does not refresh data even when refresh is done manually with
records refresh or F9. the only way to get the new data is to close the app
and reopen it.
 
The only difference between this WS and others is that it goes through two
GB switches to get to the BE. The others go through one switch. Any ideas on
why this may be happening?
 
BTW this is not my app but I have access to the source code. The developer
has not been able to figure this out on her own.
 
TIA
John B.


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com