Slow tables

Q

Question Boy

For some reason, hopefully someone can enlighten me, opening linked tables.
When I open them in the back-end, they open immediately, but when I open the
same table from the front-end it is measurably longer (30+ seconds)? Does
anyone know why the huge difference? and are there any things I can do to
resolve this 'latency'?

Thank you,

QB
 
J

John W. Vinson

For some reason, hopefully someone can enlighten me, opening linked tables.
When I open them in the back-end, they open immediately, but when I open the
same table from the front-end it is measurably longer (30+ seconds)? Does
anyone know why the huge difference? and are there any things I can do to
resolve this 'latency'?

Thank you,

QB
Click to expand...

Opening a persistant recordset to any table in the backend can make a big
difference here. Also, you should turn off Name Autocorrect and all
Subdatasheets. Check out the Performance FAQ at

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

for some other suggestions.
 
Top