Slow tables

[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

 

[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

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.