What are you expecting to happen?????

Don't you think there'd be HUGE outcry if BEGIN TRANSACTION / END TRANSACTION performed incorrectly????

Why do you think moving to a "SQL-type of database" will 'solve' your dilemma?



>I added Set Reprocess to Automatic and got a dead lock, one screen showed 'Attempting to lock... press ESC to cancel' while the other 'Record not available... please wait'.
>set reprocess to 2 desn't help either. besides 'file in used' problem, I also got Open File screen. just wonder if I switch to SQL-type of database, it will be more solid.
>
>thanks for the help.
>
>Robert