R
Renvik
I am experiencing difficulty in copying a table from one db to another;
Using the TransferDatabase command (using a macro) I copy a table from the
_fe db to _be db (the tbl in the _be is linked to _fe). This operation
overwrites the existing table in the _be and has been working fine for quite
some time and continues to work.
I did a similar thing for another table in exactly the same manner, but now
I get a message "can not lock table - it may be used by another person or
process", what has really got me baffled is that sometimes it works and
sometimes it does not!
I have compacted/repaired/recompiled the _fe db, but the problem persists,
even when the above operation is the very first operation I perform.
Any insight will be much appreciated. Thank you.
Using the TransferDatabase command (using a macro) I copy a table from the
_fe db to _be db (the tbl in the _be is linked to _fe). This operation
overwrites the existing table in the _be and has been working fine for quite
some time and continues to work.
I did a similar thing for another table in exactly the same manner, but now
I get a message "can not lock table - it may be used by another person or
process", what has really got me baffled is that sometimes it works and
sometimes it does not!
I have compacted/repaired/recompiled the _fe db, but the problem persists,
even when the above operation is the very first operation I perform.
Any insight will be much appreciated. Thank you.