Keeping the user interface components on the local machine dramatically
improves performance. There is no need to move forms, queries, or reports across the network.
These objects are much more easily manipulated on the local machine than when accessed across
the network.
All shared tables and tables that are changed at regular intervals really should be placed in the
back-end database kept on the server. The server database is opened in shared mode, making all of
its objects accessible to multiple users. The tables in the server database are linked to the front-end
.accdb on each user??™s desktop. (There is no problem with simultaneously linking the same table
to multiple databases.)
Obviously, with more than one person using the data within a table, the possibility exists that the
same record will be edited by multiple users. Jet handles this problem by locking a record as it is
edited by a user. A lock contention occurs when more than one user tries to update the same
record. Only one user will have ???live??? access to the record??”all other users will either be locked or
have their changes held up until the record holder is done making changes.
Pages:
1341
1342
1343
1344
1345
1346
1347
1348
1349
1350
1351
1352
1353
1354
1355
1356
1357
1358
1359
1360
1361
1362
1363
1364
1365