I have a database and everything works fine.
If I want to insert into one table I get the following error.
All other tables work fine.

'ElevateDB Error #300 Cannot lock the database SKraft for transaction
access'

Lock of other tables works fine.
How can I find out or where I have to look for the reason of this
message?


Karlheinz

KHJ


SKraft is probably being locked for exclusive access. From the pdf manual

The most basic form of exception handling is to use the try..except block (Delphi and Lazarus) or try..catch
(C++Builder) to locally trap for specific error conditions. The error code that is returned when an open fails due
to an exclusive lock problem is 300, which is defined as EDB_ERROR_LOCK in the edberror unit. The following
example shows how to trap for such an exception on open and display an appropriate error message to the user:

What you need to do is check wether any table or query component you have is set to exclusive. The other potential cause is that somewhere someone or something is attempting to alter the structure of the table - this requires exclusive access and if they started before you that would explain it eg you might be altering SKraft on start up and have forgotten to unprepare and close the query that's doing it.

Roy Lambert [Team Elevate]

Roy Lambert wrote:

> KHJ
>
>
> SKraft is probably being locked for exclusive access. From the pdf
> manual


Thanks Roy, found the problem with your hints.

Karlheinz