|
Home > Archive > MS Access Multiuser > August 2005 > Priority of Objects for speed
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Priority of Objects for speed
|
|
|
| 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
| |
| Paul Overway 2005-08-19, 1:27 pm |
| 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.
--
Paul Overway
Logico Solutions, LLC
www.logico-solutions.com
"Gene" <Gene@discussions.microsoft.com> wrote in message
news:8F81F78C-9FBB-4203-84EA- B3807E451D25@microso
ft.com...
> 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
|
|
|
|
|