Set multiuser query options (MDB)

You can lock all records in the underlying table or only the record that you're editing. Either way, other users can't change the record in the underlying table while you are editing it in the query's results.

1. Open a query in Design view. In a multiuser environment, confirm that all users have closed the query, the underlying table or query, and other objects based on the query.
2. Select the query by clicking anywhere in query Design view outside the design grid and the field lists.
3. Click Properties on the toolbar to display the query's property sheet.
4. Click the RecordLocks property setting you want to use.

A query that uses an ODBC database as its underlying source of data might encounter delays due to network traffic or heavy use of the ODBC server.

1. Open a query in Design view.
2. Select the query by clicking anywhere in query Design view outside the design grid and the field lists.
3. Click Properties on the toolbar to display the query's property sheet.
4. Set the ODBCTimeout property to the number of seconds that the query waits before displaying a time-out error. The default is 60 seconds.

Note  If you set the property to zero, no time-out error occurs.