7039 File already open

Advantage Error Guide

A sharing mode mismatch has occurred. Another user or connection has the file in question opened with a conflicting sharing mode.

Problem1: The user attempted to open a table or an index file for EXCLUSIVE use when another user already had the file open in SHARED mode.

Solution1: Determine which user(s) has the specified file open in SHARED mode and have that user(s) close the file before attempting to open the file for EXCLUSIVE use.

 

Problem2: The user attempted to open a table or an index file for SHARED use when another user already had the file open in EXCLUSIVE mode.

Solution2: Determine which user(s) has the specified file open in EXCLUSIVE mode and have that user(s) close the file before attempting to open the file

 

Problem3: The user attempted to open a table or an index file for EXCLUSIVE use when another user already had the file open in EXCLUSIVE mode.

Solution3: Determine which user(s) has the specified file open in EXCLUSIVE mode and have that user(s) close the file before attempting to open the file.