Specifies how locking is handled in the database and specifies the start ID for elements on new objects.
To open this window, on the File menu, choose Database, choose Alter, and then choose the Advanced tab.
Specifies whether a session waits to place a lock on a resource that has already been locked by another session.
If you clear this field, then the session waits indefinitely.
Timeout duration (sec)
Specifies the maximum length of time that a session waits to place a lock on a resource that has already been locked by another session. The default value is 10 seconds.
Start ID (UidOffset)
Specifies the start ID for elements on new objects. When you create a new table, page, report, codeunit, query, or XMLport, the elements have IDs that are offset by the Start ID (UidOffset) value that you specify. Object elements include containers, groups, fields, parts, DataItems, columns, filters, variables, functions, or text constants.
You must specify an Integer that is greater than or equal to 0.
The default value is 1.
TasksHow to: Alter Databases
How to: Specify the Start ID Offset of Elements on Objects
ConceptsAltering Databases - General Tab
Altering Databases - Database Files Tab
Altering Databases - Transaction Log Files Tab
Altering Databases - Collation Tab
Altering Databases - Options Tab
Altering Databases - Integration Tab