Linked tables very slow to open: A2K FE / A97 BE

[Glenn7691]

I have an environment running a mixture of Win 98/XP and MS Access 97 &
Access 2002 computers. Application that is causing problem is an Access 2002
database (on local drive) linking to tables in an Access 97 database (on
network drive) under Win 98 on a PIII (64MB RAM). Opening even the simplest
table (no more than a dozen records) takes more than a minute.
By comparison a 2002 FE (local) & 2002 BE (network) configuration, the table
opens almost instaneously. Likewise a 2002 FE (local) & 97 BE (local)
configuration.
Likewise a 2002 FE (local) & 97 BE (network) under Win XP on a P4 computer.

Option to upgrade all PCs to common Office 2002 platform not feasible at
present (we are a welfare agency with minimal infrastructure funding).
Any suggestions on cause of slow network performance would be appreciated.
Thanks.

 

[Nikos Yannacopoulos]

Glenn,

Check out this link:

http://www.granite.ab.ca/access/performancefaq.htm

It's a good start.

HTH,
Nikos

 

[Glenn7691]

Thanks Nikos for the reference. I have previously come across this site and
have addressed the issues raised eg LDP locking, subdatasheets & track name
autocorrect to no avail.

 

[Albert D.Kallal]

Thanks Nikos for the reference. I have previously come across this site
and
have addressed the issues raised eg LDP locking, subdatasheets & track
name
autocorrect to no avail.

Do note, that 9 out of 10 times, making a persistent connection will fix
your problem. That means in the startup code you open a table to the back
end, and KEEP IT OPEN (either open a form attached to a BE table, and then
min it...or open a table to a global recordset). Doing either one should
fix your problem. This "fix" is mentioned in Tony's list..and ranks near the
top...

The other thing to check for is any linked tables that in fact link to no
where!!