Priority of Objects for speed

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gene - 19 Aug 2005 16:07 GMT

When multiple users are accessing the same table, is it faster for the system
overall to use a querry of a table for editing rather than opening the table
for editing. Sometimes when a table is opened directly, it seems to slow up
other users access to that table. Thanks
Gene

Reply to this Message

Paul Overway - 19 Aug 2005 17:02 GMT

It depends on how the table is being opened and what record locking option
is used. In any case, if you use a query with a where clause restricting
the recordset to the single record being edited vs the entire table, it
should open faster.

Signature

Paul Overway
Logico Solutions, LLC
www.logico-solutions.com

> When multiple users are accessing the same table, is it faster for the
> system
[quoted text clipped - 4 lines]
> other users access to that table. Thanks
> Gene

Reply to this Message