I'm creating a script which will re-claim sequence numbers in a table by 'packing' the existing sequence numbers. My questions is if I lock the table in access exclusive mode, and an insert into that table occurs after the lock, with the insert be blocked before or after the nextval is chosen? Thanks, Rob Robert Creager Senior Software Engineer Client Server Library 303.673.2365 V 303.661.5379 F 888.912.4458 P StorageTek INFORMATION made POWERFUL ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]