Posted by andy on 11/01/05 13:12

With complex access2 apps I used to increase buffer size. As you're
pulling a shed load of data at a time that could well speed things up a
bit. Never tried it but maybe increasing threads would also help.

I would think replacing the way the users are using built in access
tools with functionality in a front end designed to reduce the amount
of data pulled is your best bet. This can of course be tricky as you'd
have to justify work and re-educate people.

The way it works at the moment sounds like you may as well just dump
the database out of sql server to an access copy overnight then the
user just copies this across and works off their C drive.

[Back to original message]